SQL Server Rocks!
  • Home
  • Me
  • ado.sql ltd
  • Contact
  • Ancestry
  • Search

Xml

A collection of 14 posts

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

  • Arthur Olcot
2 min read
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

  • Arthur Olcot
1 min read
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

  • Arthur Olcot
3 min read
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

  • Arthur Olcot
5 min read
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

  • Arthur Olcot
6 min read
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

  • Arthur Olcot
2 min read
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

  • Arthur Olcot
3 min read
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

  • Arthur Olcot
2 min read
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

  • Arthur Olcot
5 min read
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

  • Arthur Olcot
8 min read
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

  • Arthur Olcot
11 min read
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

  • Arthur Olcot
4 min read
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

  • Arthur Olcot
6 min read
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

  • Arthur Olcot
2 min read
SQL Server Rocks! © 2019
Latest Posts Twitter Ghost