/ 触发器添加到多个表 CREATETRIGGER[whm03_insert]ON[dbo].[whm03] FORINSERT AS insert whm03_Del selecttop1*from whm03 orderby id desc / 触发器删除多个表 CREATETRIGGER[whm03_Del]ON[dbo].[User] FORdelete AS Delete Boke_User From Boke_User br , Deleted d Where br.UserName=d.UserName / 触发器修改多个表 CREATETRIGGER[whm03_Update]ON[dbo].[User] FORUPDATE AS ifUpdate(UserName) begin Update br Set br.UserName=i.UserName From Boke_User br , Deleted d ,Inserted i Where br.UserName=d.UserName end