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
触发器 判断insert , update ,delete 的方法
最新推荐文章于 2020-12-04 09:05:49 发布