p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   Need Info (http://p2p.wrox.com/showthread.php?t=34227)

mr_shoaib October 13th, 2005 02:43 AM

Need Info
 
Hello
I want to know that how i can insert data at the same time in two tables(parent child relationship tables), in Query and in Stored Procedures. I will appreciate ur response ASAP.
Thanks

Shoaib Shaikh

SqlMenace October 17th, 2005 07:02 AM

Wrap the 2 inserts into a transaction, you cannot insert into 2 tables at the same time

http://sqlservercode.blogspot.com/


All times are GMT -4. The time now is 09:44 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.