For details of XML sort ordering, see “Sort ordering in XML Services”.
xmlparse uses the sort ordering specified by the sp_configure option default xml sort order, and the same ordering for XML indexes. XML stores the sort ordering name in the image generated by xmlparse, called the parsed XML sort order of the document.
All functions that reference a parsed XML document raise an exception when the parsed XML sort order is different from the current default XML sort order.
