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.
SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan
Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also…
Read More
SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian
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:
SQLAuthority News – Converting a Delimited String of Values into Columns
This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level. Two blogs which I am going to mention here are as…
Read MoreSQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that…
Read More
SQL SERVER – Validate an XML Document in TSQL using XSD by Jacob Sebastian
Let us learn about XML Document in TSQL using XSD by Jacob Sebastian.
SQL SERVER – Comma Separated Values (CSV) from Table Column
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.