SQL Service 触发器判断 插入 新增 删除

【SQL触发器】Inserted和deleted详解

更新操作  if exists(select 1 from inserted) and exists(select 1 from deleted)

插入操作 if (exists (select 1 from inserted) and not exists (select 1 from deleted))

删除操作 if (not exists (select 1 from inserted) and exists (select 1 from deleted))