--一个触发器不行,要两个,另外,注意触发器中的+和-
create trigger trig_gathing on gathing
for insert,update,delete
as
update result set 余额=余额+isnull(a.金额,0)-isnull(b.金额,0) from inserted a,deleted b where .....
create trigger trig_payment on payment
for insert,update,delete
as
update result set 余额=余额-isnull(*a.金额,0)+isnull(b.金额,0) from inserted a,deleted b where .....
create trigger trig_gathing on gathing
for insert,update,delete
as
update result set 余额=余额+isnull(a.金额,0)-isnull(b.金额,0) from inserted a,deleted b where .....
create trigger trig_payment on payment
for insert,update,delete
as
update result set 余额=余额-isnull(*a.金额,0)+isnull(b.金额,0) from inserted a,deleted b where .....
create trigger trig_gathing on gathing
for insert,update,delete
as
update result set 余额=余额+isnull(a.金额,0)-isnull(b.金额,0) from inserted a,deleted b where .....
create trigger trig_payment on payment
for insert,update,delete
as
update result set 余额=余额-isnull(a.金额,0)+isnull(b.金额,0) from inserted a,deleted b where .....
as
update result set 修改字段=inserted.值+修改字段的值 from result,inserted where 关联条件
update result set 修改字段=修改字段的值-deleted.值 from result,inserted where 关联条件
go
同理写出payment的触发器就可以了。
FOR INSERT
AS
update result set 余额+tem.金额 from inserted tem where tem.产品编号=result.产品编号
goCREATE TRIGGER 名2 ON payment
FOR INSERT
AS
update result set 余额-tem.金额 from inserted tem where tem.产品编号=result.产品编号
go