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 »
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 »
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 »
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 »
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. »
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 »
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 »
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 »
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( »
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( »