/ 触发器添加到多个表
CREATE TRIGGER [TRIGGER_insert] ON [dbo].[company]
FOR INSERT
AS
insert Company_Del
select top 1 * from company order by id desc
/ 触发器删除多个表
CREATE TRIGGER [TRIGGER_Del] ON [dbo].[Dv_User]
FOR delete
AS
Delete Dv_Boke_User
From Dv_Boke_User br , Deleted d
Where br.UserName=d.UserName
/ 触发器修改多个表
CREATE TRIGGER [TRIGGER_Update] ON [dbo].[Dv_User]
FOR UPDATE
AS
if Update(UserName)
begin
Update br
Set br.UserName=i.UserName
From Dv_Boke_User br , Deleted d ,Inserted i
Where br.UserName=d.UserName
end