在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