Ashishblog.com

In this article, I talked about how to parse XML or import XML to SQL Server Database Table.

XML File:

To Query XML File we need to store in to xml variable @MyXML:

Now we use SQL query to get Order header from @MyXML:

Now we use SQL query to get Order Items from @MyXML:

Full Code:



Thanks

Related posts:

Import/Export Excel (.Xlsx) or (.Xls) File into SQL Server

IF THEN in SQL SELECT Statement

Convert nvarchar to float or number in sql