In this blog post, we will learn about methods for accessing SQL Server XML DataType. Here is an article which discusses the Author’s Perspective.
One of the most common problem SQL Server developers face while dealing with XML is related to writing the correct XPath expression to read a specific value from an XML document. I usually get a lot of questions by email, on my blog or in the forums which looks like the following:
Let us learn about XML Document in TSQL using XSD by Jacob Sebastian.
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma Separated Values (CSV) from Table Column is a very common task, and we all do this many times a day. Let us see the example that I use frequently and its output.