在Sql Server触发器操作类型

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

 

From: http://www.blogjava.net/willpower88/archive/2008/02/28/182767.html

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

--&gt 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  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14906671/viewspace-608765/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14906671/viewspace-608765/