select * From tb_topic
select * from tb_reply
--將主題信息表中的ID插入到回復(fù)信息表的觸發(fā)器開始
--作者：SK
--時(shí)間：2005-05-17
Alter Trigger t_InsertReply

On tb_topic

   For Insert 
As

   Insert into tb_reply (Topicid) Select Id From inserted  deleted
  --select Id Into tb_reply   From inserted  
--將主題信息表中的ID插入到回復(fù)信息表的觸發(fā)器結(jié)束


insert tb_topic values (3,'face0.gif','sadfsadfasdfa',default,'192.168.1.45')
select * From tb_topic
select * from tb_reply

select IDENTITYCOL from tb_topic 

sp_helptext