Ordered and Unordered Expressions (XQuery)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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.

See Also

XQuery Expressions
FLWOR Statement and Iteration (XQuery)
Path Expressions (XQuery)