create trigger t1 on lk for update
as
update kc set sl = sl - deleted.sl + inserted.sl from deleted, inserted where deleted.name = kc.name and inserted.name = kc.name
愉快的登山者 ⊙
◢◣◢◣◢◣
as
update kc set sl = sl - deleted.sl + inserted.sl from deleted, inserted where deleted.name = kc.name and inserted.name = kc.name
愉快的登山者 ⊙
◢◣◢◣◢◣
CREATE TRIGGER 名2 ON lk
FOR update
AS
update kc set sl=aa.sl from inserted aa where aa.name=kc.name
FOR insert
AS
update kc set sl=sl+aa.sl from inserted aa where aa.name=kc.name
go
FOR UPDATE
AS
UPDATE kc set s1=s1+a.s1-b.s1 from inserted a,delete b where a.name=kc.name and b.name=kc.name
FOR insert
AS
update kc set sl=sl+aa.sl from inserted aa where aa.name=kc.name
go
for update
as
update kc set sl=sl+a.sl-b.sl from inserted a,delected b where a.name=kc.name or b.name=kc.name