Ordered and Unordered Expressions (XQuery)
SQL Server 2012
By default, the ordering mode for all operations in SQL Server is ordered. Therefore, the node sequences returned by the path expressions and the FLWOR expressions, without the order by clause, are in document order.
The additional ordered and unordered syntax described in the XQuery specification is not supported.
