急.问一个触发器的问题。在线等.马上结贴
我想把三个写在一起,方便管理.仔细看了一下好象不行.这样判断好象判断不出他是插入还是修改还是删除状态的.但不知道怎么改正。请帮忙
create trigger XXX on XXX for insert,update,delete
as
IF EXISTS ( SELECT * FROM INSERTED) AND NOT EXISTS (SELECT * FROM DELETED) --insert 时触发
IF UPDATE(字段) -- update时触发
IF NOT EXISTS ( SELECT *FROM INSERTED) AND EXISTS (SELECT * FROM DELETED)
--DELETE 时触发
[解决办法]
if EXISTS ( SELECT *FROM INSERTED) AND EXISTS (SELECT * FROM DELETED) --修改时触发
[解决办法]
create trigger TR_XXX
on XXX
for insert,update,delete
as
IF EXISTS ( SELECT * FROM INSERTED) AND NOT EXISTS (SELECT * FROM DELETED) --insert 时触发
IF EXISTS ( SELECT *FROM INSERTED) AND EXISTS (SELECT * FROM DELETED)
-- update时触发
IF NOT EXISTS ( SELECT *FROM INSERTED) AND EXISTS (SELECT * FROM DELETED)
--DELETE 时触发
[解决办法]
楼主把表的结构贴出来，和要实现的效果
