Importing and Processing Data from XML files into SQL Server tables

This article explain various methods of Importing the XML File

- Importing XML data from XML file using OPENROWSET
- Process XML data using OPENXML function

Link : http://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/