create trigger tr_test on t1 for update as begin if not update(b) return update t2 set b=a.b from insert a,t2 b where a.a=b.a end
if object_id('t1') is not null drop table t1 go create table t1 (d1 varchar(10),d2 varchar(10),d3 varchar(10)) insert t1(d1,d2,d3) select 'a','b','c'if object_id('t2') is not null drop table t2 go create table t2 (m1 varchar(10),m2 varchar(10),m3 varchar(10)) insert t2(m1,m2,m3) select 'a','b','d'create trigger tr_t1_u on t1 for update as begin update t2 set m2=d2 from t1 where t1.d1=t2.m1 end
if object_id('t1') is not null drop table t1 go create table t1 (d1 varchar(10),d2 varchar(10),d3 varchar(10)) insert t1(d1,d2,d3) select 'a','b','c'if object_id('t2') is not null drop table t2 go create table t2 (m1 varchar(10),m2 varchar(10),m3 varchar(10)) insert t2(m1,m2,m3) select 'a','b','d'create trigger tr_t1_u on t1 for update as begin update t2 set m2=d2 from t1 where t1.d1=t2.m1 end
on t1
for update
as
begin
if not update(b) return
update t2 set b=a.b from insert a,t2 b where a.a=b.a
end
go
create table t1 (d1 varchar(10),d2 varchar(10),d3 varchar(10))
insert t1(d1,d2,d3)
select 'a','b','c'if object_id('t2') is not null drop table t2
go
create table t2 (m1 varchar(10),m2 varchar(10),m3 varchar(10))
insert t2(m1,m2,m3)
select 'a','b','d'create trigger tr_t1_u
on t1
for update
as
begin update t2
set m2=d2
from t1
where t1.d1=t2.m1
end
go
create table t1 (d1 varchar(10),d2 varchar(10),d3 varchar(10))
insert t1(d1,d2,d3)
select 'a','b','c'if object_id('t2') is not null drop table t2
go
create table t2 (m1 varchar(10),m2 varchar(10),m3 varchar(10))
insert t2(m1,m2,m3)
select 'a','b','d'create trigger tr_t1_u
on t1
for update
as
begin update t2
set m2=d2
from t1
where t1.d1=t2.m1
end