--一个触发器内三种INSERT,UPDATE,DELETE状态
If Exists(Select 1 From sys.triggers Where name='tr_eBB_Agreement_File')
Drop Trigger tr_eBB_Agreement_File
Go
Create Trigger tr_eBB_Agreement_File
On eBB_Agreement_File After Insert,Update,Delete
As
--Insert
--插入操作(Insert):Inserted表有数据,Deleted表无数据
If Exists (select 1 from Inserted) and not Exists (select 1 from Deleted)
Begin
print 'Insert'
End
--Update
--更新操作(Update):Inserted表有数据(新数据),Deleted表有数据(旧数据)
IF Exists(select 1 from Inserted)and Exists(select 1 from Deleted)
Begin
print 'Update'
End
--Deleted
--删除操作(Delete):Inserted表无数据,Deleted表有数据
IF Exists(select 1 from Deleted)and not Exists(select 1 from Inserted)
Begin
print 'Deleted'
End
Go
If Exists(Select 1 From sys.triggers Where name='tr_eBB_Agreement_File')
Drop Trigger tr_eBB_Agreement_File
Go
Create Trigger tr_eBB_Agreement_File
On eBB_Agreement_File After Insert,Update,Delete
As
--Insert
--插入操作(Insert):Inserted表有数据,Deleted表无数据
If Exists (select 1 from Inserted) and not Exists (select 1 from Deleted)
Begin
print 'Insert'
End
--Update
--更新操作(Update):Inserted表有数据(新数据),Deleted表有数据(旧数据)
IF Exists(select 1 from Inserted)and Exists(select 1 from Deleted)
Begin
print 'Update'
End
--Deleted
--删除操作(Delete):Inserted表无数据,Deleted表有数据
IF Exists(select 1 from Deleted)and not Exists(select 1 from Inserted)
Begin
print 'Deleted'
End
Go