ARZ ARZ - 2 years ago 54
SQL Question

Sort all attributes of XML in SQL query using XQuery

How can get the XML with sorted attributes using XQuery in SQL?

for example for this XML:

<root><book b='' c='' a=''/></root>

must return:

<root><book a='' b='' c=''/></root>

Answer Source

From Limitations of the xml Data Type.

The order of attributes in an XML instance is not preserved. When you query the XML instance stored in the xml type column, the order of attributes in the resulting XML may be different from the original XML instance.

So even if you could figure out a way of sorting the attributes, you can not trust that the XML data type in SQL Server will preserve the order you want.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download