34,838
社区成员




insert test2(id2,name2)
select id2,case when exists(select 1 from test1 where id1=id2) then 'new'+name2 else name2 end
[Quote=引用 2 楼 feixianxxx 的回复:]
SQL codecreatetrigger kkon test2
afterinsertasbeginifexists(select*from insertedwhere id2in (select id1from test1))update test2set name2='new'+inserted.name2from insertedjoin test2on inserted.id1=test¡
[/Quote]
修改 汗 。。
create trigger kk on test2
after insert
as
begin
if exists(select * from inserted where id2 in (select id1 from test1))
update test2
set name2='new'+inserted.name2
from inserted join test2 on inserted.id2=test2.id2
end
create trigger kk on test2
after insert
as
begin
if exists(select * from inserted where id2 in (select id1 from test1))
update test2
set name2='new'+inserted.name2
from inserted join test2 on inserted.id1=test2.id1
end
create trigger kk on test2
insert
as
begin
if exists(select * from inserted where id2 in (select id1 from test1))
update test2
set name2='new'+inserted.name2
from inserted join test2 on inserted.id1=test2.id1
end