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

Question

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

Vinay Singh · Answer

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 Jadav · Answer

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