/
触发器添加到多个表
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
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