CREATE TRIGGER trig_test ON GameUser FOR insert,delete ASdelete a from level_log a,deleted b where a.gameuser = b.strUserIDinsert into level_log(gameuser,level_use) select strUserID,1 from inserted
CREATE TRIGGER trig_test ON GameUser FOR insert,delete AS begin if update(id) insert into level_log(gameuser,level_use) select strUserID,1 from inserted else delete a from level_log a inner join deleted b on a.gameuser = b.strUserID end
++简单的insert和delete触发器
CREATE TRIGGER trig_test ON GameUser FOR insert,delete AS begin if update(struserid) insert into level_log(gameuser,level_use) select strUserID,1 from inserted else delete a from level_log a inner join deleted b on a.gameuser = b.strUserID end
CREATE TRIGGER trig_test ON GameUser
FOR insert,delete
ASdelete a from level_log a,deleted b where a.gameuser = b.strUserIDinsert into level_log(gameuser,level_use) select strUserID,1 from inserted
FOR insert,delete
AS
begin
if update(id)
insert into level_log(gameuser,level_use) select strUserID,1 from inserted
else
delete a from level_log a inner join deleted b on a.gameuser = b.strUserID
end
++简单的insert和delete触发器
FOR insert,delete
AS
begin
if update(struserid)
insert into level_log(gameuser,level_use) select strUserID,1 from inserted
else
delete a from level_log a inner join deleted b on a.gameuser = b.strUserID
end