468,107 Members | 1,490 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

how do I INSERT data into multiple tables at once?

Hai to one and all... I am using The VB.Net 2005 and SQL server2000 .. I need to insert the Data into multiple tables at once.
Oct 11 '08 #1
3 1218
4,871 Expert 4TB
It depends on what you mean by "at once". Consecutive queries are likely to lead to fewer errors and better error handling, in one block of code. Otherwise try running in one stored procedure.
Oct 12 '08 #2
692 Expert 512MB

Please specify more details about your problem.
Please refer This Article which explains how to insert data into multiple tables.
Oct 12 '08 #3
Hey !

You can simply write a stored procedure which will help you to insert data into multiple tables at single point on time. If this is not what you are expecting then please be more elaborative in your question.
Oct 12 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Jason L James | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.