Ordered and Unordered Expressions (XQuery)
By default, the ordering mode for all operations in SQL Server 2005 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
Concepts
XQuery Expressions
FLWOR Statement and Iteration (XQuery)
Path Expressions (XQuery)