触发器 判断insert , update ,delete 的方法

Create trigger [abc]
on [dbo].[abcd] after insert,update,DELETE
as
--新增
if not exists(select 1 from deleted)

--删除
if not exists(select 1 from inserted)

--修改
if exists(select 1 from inserted) and exists(select 1 from deleted)
...

go