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.