34,576
社区成员
发帖
与我相关
我的任务
分享
create table a(a1 int,a2 int)
insert into a select 1,1
insert into a select 2,2
create table b(b1 int,b2 int)
insert into b select 1,1
insert into b select 2,1
insert into b select 3,2
insert into b select 4,2
insert into b select 5,2
create trigger tr_a
on a
for update
as
begin
update a set b2=b.a2 from b a,deleted c,inserted b
where a.b2=c.a2 and c.a1=b.a1
end
update a set a2=5 where a1=1
select * from a
select * from b
--a
a1 a2
1 5
2 2
--b
b1 b2
1 5
2 5
3 2
4 2
5 2
create trigger my_trig on A for update
as
update b set b2 = a.a2 from b,a where b.b1 = a.a1