Tag Info

New answers tagged

0

Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008.


-1

refer this link http://pratchev.blogspot.in/2008/11/import-xml-file-to-sql-table.html Import XML File to SQL Table Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized ...



Top 50 recent answers are included