SQLServerCentral.com Content tagged Blogs, XML

Using XQuery to remove duplicate values or duplicate nodes from an xml instance

Thu, 20 Dec 2012 07:00:00 UT

Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...

Shredding a simple xml structure to a single row flat table

Tue, 22 May 2012 06:00:00 UT

I was helping out a user on the forums the other day where they were asking questions about shredding an...

Introduction to XML DML (Part 3) - Using the modify() method: delete

Mon, 06 Feb 2012 07:00:00 UT

This is the last part of a 3 part blog which will attempt to show some different ways of how...

FOR XML PATH using node tests in column aliases

Tue, 20 Dec 2011 07:00:00 UT

I've used SQL to generate countless blobs of xml over the years and one feature that I have come to...

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

XQuery for the Non-Expert – @Variable Use

Thu, 20 Jan 2011 07:00:00 UT

Talk to the Experts In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...

Sparse Columns – ConvertSVtoXML & XMLToResv

Thu, 15 Oct 2009 06:00:00 UT

Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.