Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Insert into multiple tables

Author  Topic 

rama.nelluru
Starting Member

37 Posts

Posted - 2012-07-25 : 14:25:51
Posted - 07/25/2012 : 13:35:37
--------------------------------------------------------------------------------

Hi ,

I have to insert data into 3 tables.

data i need to insert is

unit1, unit2,unit3,id1,id2,id3-- one table1
sn,range,area,section,id1,id2,id3-----2nd table2
bdate,praid,numrows,plant,id1,id2,id3--------table3
and all the three table are having PK AND FK
ON COLUMNS ID2,ID2,ID3.

need single saql statement to insert data into 3 tables .

Thanks,
Ram



RAM

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-07-25 : 14:26:57
Duplicate of:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=177155
Go to Top of Page
   

- Advertisement -