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

DECLARE    @IsInsert bit,    @IsUpdate bit,    @IsDelete bitIF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted)    SET @IsInsert = 1ELSE    SET @IsInsert = 0IF EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)    SET @IsUpdate = 1ELSE    SET @IsUpdate = 0IF NOT EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)    SET @IsDelete = 1ELSE    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