触发器

CREATE TRIGGER tg_name

ON TableName

FOR INSERT,UPDATE,DELETE /*一种或多种*/
AS
 declare ... ;

 

 select ... from deleted; /*取得更新之前数据*/
 select ... from inserted;/*取得更新之后数据*/

 if update(field name) /*针对具体列*/

      begin

         .....

      end