在Sql Server触发器中判断操作是Insert还是Update还是Delete

DECLARE
    @IsInsert bit,
    @IsUpdate bit,
    @IsDelete bit

IF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted)
    SET @IsInsert = 1
ELSE
    SET @IsInsert = 0

IF EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
    SET @IsUpdate = 1
ELSE
    SET @IsUpdate = 0

IF NOT EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
    SET @IsDelete = 1
ELSE
    SET @IsDelete = 0
create   trigger   Update_Del   on   Table
  for   update,delete
  as
  if   not   exists(select   1   from   inserted)
  begin   /*inserted表无记录，是删除*/
  end
  else
  begin   /*是更新*/   end
  go

本站仅提供存储服务，所有内容均由用户发布，如发现有害或侵权内容，请点击举报。