Loading

How to insert data in multilple tables from xml file in sql?

Amar Bisht

12y1.1k

how to read xml file and insert data in multiple tables in sql server 2008?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi
Try the below link
http://www.aspsnippets.com/Articles/Bulk-Insert-data-into-SQL-database-using-XML-file-in-ASPNet-using-C-VBNET.aspx
http://csharp.net-informations.com/xml/xml-to-database.htm
Vishal Jadav10y ago
Hi,
Suppose you have xml containing data for multiple tables use UserDefinedTableTypes
using which you can send all the data at once to procedure and save it in a single statement for a table.
if you need any example please let me know.
Hope it helps.
Thanks..