" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Manipulating SQL SERVER database table’s data with XML XPath and XQuery

Posted on November 24th, 2015 by Bishwaranjan Sandhu

Sometimes we need SQL Server tables’s data(tables with Primary-Foreign key relationship) as a XML type to workout some of our need. With the introduction of the XML datatype in SQL SERVER 2005, it provides the flexibility to generate XML type from the data contained inside sql server tables. Here in this tip, I will be […]