怎样写这个触发器（急！）

[wendaoshuangyue]

有两个表：
test1：id1，name1
test2：id2，name2
在往表test2插入一条数据的时候，我要判断新插入的这条数据的字段id2的值在表test1中是否存在，如果存在则将这条记录的name2的值修改为'new'+name2,如果不存在则不做任何变动。
请教各位大侠这个触发器该怎么写？急，在线等！我用的是sql server.

[feixianxxx]

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

[feixianxxx]

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

[feixianxxx]

[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

[贾桂权]

不用写触发器。

insert test2(id2,name2)
    select id2,case when exists(select 1 from test1 where id1=id2) then 'new'+name2 else name2 end

[nandorin]

CREATE TRIGGER TRIGGER_TEST2_INS ON DBO.TEST2

FOR INSERT

AS

IF EXISTS(SELECT * FROM TEST2 WHERE IID IN (SELECT IID FROM TEST1) )

BEGIN

UPDATE A SET A.INAME='NEW'+B.INAME FROM TEST1 A,INSERTED B WHERE A.IID=B.IID

END

[jwdream2008]

T-Mac is NO.1!