Posted by David Portas on 12/19/06 07:31

Russ Rose wrote:
> >
> > Tables are not ordered.
>
> Even clustered ones?
>

Even clustered tables are not logically ordered. There is no way to
guarantee that a query against a clustered table will return a result
that respects the order of the clustered index key UNLESS you specify
ORDER BY in the query

> >
> > Therefor the fact that SQL 2000 allowed the above syntax is basically
> > "wrong".
>
> Yet it works...
>

It does not "work" the way you think. When querying the view in some
cases you will get data returned in the same order as the ORDER BY
clause in the view. In some cases you will not. This is consistent with
the documented behaviour: the order is undefined unless you specify
ORDER BY.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]