Microsoft KB Archive/266332

= BUG: SQL Server Books Online Incorrectly States That SET ROWCOUNT is Applied Before ORDER BY =

Article ID: 266332

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q266332



BUG #: 58088 (SQLBUG_70)



SYMPTOMS
SQL Server Books Online states the following in the &quot;Limiting Result Sets Using TOP and PERCENT&quot; topic:

The SET ROWCOUNT limit applies to building the rows in the result set before an ORDER BY is evaluated. Even if ORDER BY is specified, the SELECT statement is terminated when n rows have been selected. n rows are selected, then ordered and returned to the client.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.