how do I INSERT data into multiple tables at once?

varunkumarid

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.

kenobewan

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.

shweta123

Hi,

Please specify more details about your problem.
Please refer This Article which explains how to insert data into multiple tables.

onlyamzy

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.

how do I INSERT data into multiple tables at once?

re: how do I INSERT data into multiple tables at once?

re: how do I INSERT data into multiple tables at once?

re: how do I INSERT data into multiple tables at once?

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about