SELECT (Level 2)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| A SELECT statement without an ORDER BY clause returned the rows in an apparent ordered set. | An explicit ORDER BY clause for a SELECT statement is required to ensure any useful ordering of data. In addition, the exact results depend upon the collation being used.
Expect different results as compared to earlier versions of SQL Server. Add an explicit ORDER BY clause to all SELECT statements needing to produce ordered rows. |