/ 触发器添加到多个表 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
/ 触发器添加到多个表CREATE TRIGGER [whm03_insert] ON [dbo].[whm03] FOR INSERTASinsert whm03_Delselect top 1 * from whm03 order by id desc/ 触发器删除多个表CREATE TRIGGER [whm03_Del] ON [dbo].[User] FOR deleteAS De