create trigger update_tb
on a
instead of update
as
begin
if (select count(*) from a,inserted where a.a1=b.a1 )<>0
begin
如果a1存在就更新a2,同时更新b的b1=a2 end
else
begin
如果a1不存在,就插入a1,a2,同时更新b的b1=a2
endend
on a
instead of update
as
begin
if (select count(*) from a,inserted where a.a1=b.a1 )<>0
begin
如果a1存在就更新a2,同时更新b的b1=a2 end
else
begin
如果a1不存在,就插入a1,a2,同时更新b的b1=a2
endend
如果a1存在就更新a2,同时更新b的b1=a2
如果a1不存在,就插入a1,a2,同时更新b的b1=a2
非常感谢!!
create trigger tr_a_update_insert
on a
for insert,update
as
begin
set nocount on
update b
set b1=i.a2
from b,inserted iend