简单Sql Server2005触发器问题

[gaoweipeng7851]

现在有两个表：问题表（问题编号，题目，回答数），回答表（回答编号，内容，问题编号）

想实现在回答表中添加了一条记录后，问题表中的回答数自动加一，不想用程序实现，想利用触发器。

但是触发器不是很熟，还望高手指教，这种情况触发器怎么写。多谢啦！

[feixianxxx]

create trigger kk
on 回答表
after insert
as
begin
 update 问题表
 set 回答数=回答数+1
from inserted i 
where 问题表.问题编号=i.问题编号
 end

[水族杰纶]

create trigger tri_insert on 回答表
for insert
as
update 问题表 set 回答数=回答数+1 from inserted where 问题表.问题编号=inserted.问题编号

[一品梅]

create trigger answeradd
        on reply 
        for inserted
As
  begin 
  update questinaire 
    set answersets=answersets+1
     where answeradd.id=inserted.id and answeradd.id=qustionaire.questionid;
  end;

[一品梅]

create trigger answeradd
        on reply 
        for inserted
As
  begin 
  update questinaire 
    set answersets=answersets+1 from inserted
     where answeradd.id=inserted.id and answeradd.id=qustionaire.questionid;
  end;

[一品梅]

create trigger answeradd
        on reply 
        for inserted
As
  begin 
  update questinaire 
    set answersets=answersets+1 from inserted
     where inserted.id=qustionaire.questionid;
  end;

[gaoweipeng7851]

duoxie