G
gutian
Unregistered / Unconfirmed
GUEST, unregistred user!
如何使用当某条记录修改时，触发器只对这条记录进行操作。
H
hpretty
Unregistered / Unconfirmed
GUEST, unregistred user!
在你的SQL语句后面加上一个条件 where table.fields[x]=inserted.fields[x]
其中inserted 是插入后产生的临时表。
其中inserted 是插入后产生的临时表。
D
Dickson Tsen
Unregistered / Unconfirmed
GUEST, unregistred user!
I think we must add this after sql clause:
Where Table.FieldName=Deleted.FieldName
Where Table.FieldName=Deleted.FieldName
R
route
Unregistered / Unconfirmed
GUEST, unregistred user!
你应该去找一本Microsoft SQL Server 6.5 培训教程(微软认证）去读一读，
里面很详细。（简单问题不要问）
里面很详细。（简单问题不要问）
X
xin_kang
Unregistered / Unconfirmed
GUEST, unregistred user!
你应该去找一本Microsoft SQL Server 6.5 培训教程(微软认证）去读一读，
里面很详细。（简单问题不要问）
里面很详细。（简单问题不要问）
无
无情
Unregistered / Unconfirmed
GUEST, unregistred user!
俺是个穷鬼,没本钱也来这里淘淘金不行么?
淘点"简单"的沙子也成啊!
各位大哥行行好别赶我出去啊.....
(&_&
淘点"简单"的沙子也成啊!
各位大哥行行好别赶我出去啊.....
(&_&
W
wumeng
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE TRIGGER dbo.AccountingRepTrigger1 ON dbo.AccountingRep
FOR UPDATE AS
IF Update(amtUpdated)
begin
declare @a1 float
declare @a2 float
select @a1=(select amtUpdated from Inserted)
select @a2=(select amtUpdated from deleted)
update accountingRep
set balance=balance + @a1 - @a2
where tableCode=(select tableCode from deleted)
and tableNo=(select tableNo from deleted)
end
hope it can help!
FOR UPDATE AS
IF Update(amtUpdated)
begin
declare @a1 float
declare @a2 float
select @a1=(select amtUpdated from Inserted)
select @a2=(select amtUpdated from deleted)
update accountingRep
set balance=balance + @a1 - @a2
where tableCode=(select tableCode from deleted)
and tableNo=(select tableNo from deleted)
end
hope it can help!
W
wjiachun
Unregistered / Unconfirmed
GUEST, unregistred user!
多人接受答案了。
