Insert Data in SQL with ID

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
 
K

Kevin Spencer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access 2010 import/append data into table w/o overwriting existing records 0
Union Query - Select Distinct 2 fields 7
single quote in data 3
insert into 2 sql tables 5
Insert a record in one table then need the record ID for another? 1
Beginning .Net : Insert data into SQL Server Database with C#Examples and VB.Net Examples 1
Beginning .Net : Insert data into SQL Server Database with C#Examples and VB.Net Examples 2
Error inserting record into SQL Server using ADO .Net 2

Top