Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Blogs, XML Rss

   Items 1 to 7 of 7   
 

Removing HTML formatting tag - BR - from XML using XQuery

This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...  Read more...
By ArthurOlcot 2013/11/07 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,515 reads

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

Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...  Read more...
By ArthurOlcot 2012/12/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,293 reads

Shredding a simple xml structure to a single row flat table

I was helping out a user on the forums the other day where they were asking questions about shredding an...  Read more...
By 2012/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,316 reads

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

This is the last part of a 3 part blog which will attempt to show some different ways of how...  Read more...
By 2012/02/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,369 reads

FOR XML PATH using node tests in column aliases

I've used SQL to generate countless blobs of xml over the years and one feature that I have come to...  Read more...
By 2011/12/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,506 reads

XQuery for the Non-Expert – @Variable Use

Talk to the Experts In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...  Read more...
By StrateSQL 2011/01/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,137 reads

Sparse Columns – ConvertSVtoXML & XMLToResv

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.  Read more...
By Andy Warren 2009/10/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 791 reads
   Items 1 to 7 of 7   
 
Tags
sparse columns (1)    
xquery (1)