有A,B,两张表:
A表:(Brkey为B表主键)
Arkey, Brkey, Info, re
B表
Brkey,info如何写一个触发器:
要求:
1. 当B表中字段Brkey,info更新时,同步更新A表的Brkey,info信息.
2. 当B表中字段Brkey,info删除时,同步删除A表的Brkey,info那整条信息.
A表:(Brkey为B表主键)
Arkey, Brkey, Info, re
B表
Brkey,info如何写一个触发器:
要求:
1. 当B表中字段Brkey,info更新时,同步更新A表的Brkey,info信息.
2. 当B表中字段Brkey,info删除时,同步删除A表的Brkey,info那整条信息.
create trigger resetB
on B
after update,delete
as
begin
if exists(select 1 from inserted)
update ta set brkey=tb.brkey,info=tb.info from A ta inner join(
select i.brkey,i.info,d.brkey brkeyold from inserted i,deleted d)tb on ta.brkey=tb.brkeyold
else
delete from A where exists(select 1 from deleted where brkey=A.brkey)
end