View Single Post
  #2 (permalink)  
Old July 23rd, 2003, 04:59 AM
pgtips pgtips is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

After you do the 1st insert, select @@identity (or SCOPE_IDENTITY() in SQL 2000) to get the id you need to insert in the 2nd table.
Reply With Quote