How to Read XML file and XML String through SQL Stored Procedure

ObjectiveIn this article I will explain reading XML data from XML String \ XML File through SQL Stored Procedure. Stored Procedure for reading XML File.There is a XML file TestXML.xml which contains following XML data.      Vishal    Developerl        Jibin    System Analystl