View Single Post
  #1 (permalink)  
Old July 23rd, 2003, 04:47 AM
cjennings cjennings is offline
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default inserting into joined tables

I need to insert data into 2 linked tables which have unique identifiers created automatically (set as an identity in sql server). Do i need to execute multiple statements in order to do the insert or can it be done with just one.

If i do it with multiple statements how do i return the unique id from table 1 in order to insert into table 2.

Reply With Quote