Xml XQuery - Accessing the Attributes Axis Working with a sequence of attributes in XQuery is fairly straight forward with the 'attribute' axis even if you don't know or need to know the attribute names. By using this axis you
Xml And that is 2013 I've been blogging for a couple of years now and although I've never been a prolific blogger (and never will!), I like to get at least one post out a month. However next
Xml 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 within a CDATA section. Sure it is all perfectly valid XML at the
Xml Retrieving the next or previous element node value in an Xml blob using XQuery It's been a little while since I wrote a blog post on my favourite subject but this is from a thread on the SSC Xml forum that I was helping out on a
Xml 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 is relatively straight forward using XQuery. It gets a bit more complicated if
Xml Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value Not another comma separated string blog post I hear you say! I know that this topic has probably been done to death but I hope that this is a little different as it
Xml Moving xml child elements to its parent using XQuery I haven't been able to do much XQuery development recently which is a shame as I love developing with the technology in SQL. In the past I used to work with xslt's a
Xml 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 xml structure of which they didn't know the schema for. They wanted to
Xml 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 you can use the xml modify() method to update the contents of an
Xml Introduction to XML DML (Part 2) - Using the modify() method: replace value of This is the second part of a 3 part blog which will attempt to show some different ways of how you can use the xml modify() method to update the contents of an
Xml Introduction to XML DML (Part 1) - Using the modify() method: insert This is the first part of a 3 part blog which will attempt to show some different ways of how you can use the xml modify() method to update the contents of an
Xml Retrieving position() value of node by using XQuery alone You can only use the position() function within an xquery predicate and can't use it to return the position value of the node itself, which is a shame, but a couple of good
Xml 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 rely heavily upon is the ability to easily build complex xml structures by
Xml Simple XML exist performance enhancement I came across this really simple best practice from BOL for the xml method exist which when used will give you a much cleaner and faster query plan. If like me you commonly