Insert Data in SQL with ID

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Hi

I have 3 tables in SQL Server Database

Tab1 (id, lname, fname)
Tab2 (id, addr1, add2)
Tab3 (id, city, state)

I want to insert data at the same time using a single sql statment, but ID
data of table1 should be inserted in the other 2 tables

Can someone help


TIA
Barry
 
It can't be done. You can put 3 INSERT statements into a single Stored
Procedure. You can run 3 INSERT statements in a single Transaction. But you
can't insert records into 3 tables with a single SQL statement.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
 
Back
Top