V
vinge
Unregistered / Unconfirmed
GUEST, unregistred user!
向两个表中插入数据,返回第一个表的自动编号。<br> begin transaction<br> insert into Codes_Codes(CategoryID,Title,AuthorID,Codes,Notes)<br> values(@CategoryID,@Title,@AuthorID,@Codes,@Notes)<br> set @CodeID = @@Identity //放在这?如果放在最后是不是就不知道是那个表的编号了?<br> insert into Codes_History(MenderID,[Action],Content,[Date])<br> values(@AuthorID,'Insert',@Codes,getdate())<br> commit transaction<br> return @CodeID <br><br>请大家指教。