>SQL server adds an "order by" clause by select first field of query...
From the SQL server documentation: "If the query includes an ORDER BY clause, the first expression rows, or expression percent of rows, ordered by the ORDER BY clause are returned. If the query has no ORDER BY clause, the order of the rows is arbitrary."
(
http://msdn.microsoft.com/en-us/library/ms189463.aspx)
--
Christof