by Sheila Zhang
This blog is a continuation from my previous blog: How to Query Using Microsoft SQL Server to Create XML, found here. 

Another great query using Microsoft SQL Server to create XML is using this process:

You can manually define your selected SML format by using the PATH option of the FOR XML clause.  In the PATH mode, the standard XML XPath, which describes the path...

by Sheila Zhang
Using Microsoft’s SQL Server 2012 makes querying with XML a lot easier.  Microsoft’s SQL Server allows you to create XML with a SQL query or shred XML into a data table format.  I have shared with you below examples of achieving this query process faster.

When you use the "FOR XML" clause in the "SELECT- T_SQL" statement, you convert a query record set to XML...

by Sheila Zhang
I query databases almost every day. The database I work with most often is the SQL server. Microsoft recommends, as a best practice, writing standard queries. While I agree that writing standards makes code more portable, due to the ease of beginning work with new platforms, I also want to share some examples below in the Microsoft training kit that allow you to dec...