/ 触发器添加到多个表 CREATETRIGGER[TRIGGER_insert]ON[dbo].[company] FORINSERT AS insert Company_Del selecttop1*from company orderby id desc / 触发器删除多个表 CREATETRIGGER[TRIGGER_Del]ON[dbo].[Dv_User] FORdelete AS Delete Dv_Boke_User From Dv_Boke_User br , Deleted d Where br.UserName=d.UserName / 触发器修改多个表 CREATETRIGGER[TRIGGER_Update]ON[dbo].[Dv_User] FORUPDATE AS ifUpdate(UserName) begin Update br Set br.UserName=i.UserName From Dv_Boke_User br , Deleted d ,Inserted i Where br.UserName=d.UserName end