Insert Data in SQL with ID

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry - 12 Jul 2007 10:53 GMT

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

Reply to this Message

Kevin Spencer - 12 Jul 2007 11:45 GMT

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.

Signature

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

> Hi
>
[quoted text clipped - 11 lines]
> TIA
> Barry

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...