--加个条件 ALTER Trigger T_OnTestA on TestA for update as if update(aa) begin update TestB set bb=I.aa from inserted I inner join TestB B on I.a=B.b end
--测试环境保护 create table TestA(a int,aa int) insert into TestA select 1,22 union all select 2,11 create table TestB(b int,bb int) insert into TestB select 1,22 union all select 2,11 --建触发器 Create Trigger T_OnTestA on TestA for update as if update(aa) begin update TestB set bb=I.aa from inserted I inner join TestB B on I.a=B.b end--测试 update TestA set aa=22 where a=1--测试结果 b bb ----------- ----------- 1 22 2 33
ALTER Trigger T_OnTestA on TestA
for update
as
if update(aa)
begin
update TestB set bb=I.aa from inserted I inner join TestB B
on I.a=B.b
end
create table TestA(a int,aa int)
insert into TestA select 1,22
union all select 2,11
create table TestB(b int,bb int)
insert into TestB select 1,22
union all select 2,11
--建触发器
Create Trigger T_OnTestA on TestA
for update
as
if update(aa)
begin
update TestB set bb=I.aa from inserted I inner join TestB B
on I.a=B.b
end--测试
update TestA set aa=22
where a=1--测试结果
b bb
----------- -----------
1 22
2 33