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>
Attributes are unordered in XML, so the document is considered the same whichever order the attributes are printed out in. XQuery certainly has no way to change the order of attributes, and I doubt SQL XML does either.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With