SQL 触发器的编写

  /  触发器添加到多个表
CREATE   TRIGGER   [whm03 _insert ]   ON   [ dbo ] . [ whm03 ]  
FOR   INSERT
AS
insert  whm03_Del
select   top   1   *   from  whm03 order   by  id  desc

/  触发器删除多个表
CREATE   TRIGGER   [ whm03_Del ]   ON   [ dbo ] . [ User ]  
FOR   delete
AS
     Delete  Boke_User 
     From  Boke_User br , Deleted  d
     Where  br.UserName = d.UserName

/  触发器修改多个表
CREATE   TRIGGER   [ whm03_Update ]   ON   [ dbo ] . [ User ]  
FOR   UPDATE
AS
     if   Update (UserName)
     begin

     Update  br 
       Set  br.UserName = i.UserName
       From  Boke_User br , Deleted d ,Inserted i 
       Where  br.UserName = d.UserName

     end