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
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.

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


All times are GMT -4. The time now is 06:14 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.