"Ralph Ganszky" <rg@web.de> wrote in news:e59adc$kug$01$1@news.t-
online.com:

>
> I think you can have an ordered table in SQL Server if you are using a
> clustering index.
>

You think wrong. If you don't use an ORDER BY clause,
the returned order is undefined.

Sure, if you have a clustered index, AND you're only
selecting from one table, AND you're not using a where
clause that causes the optimizer to choose differently,
AND the phase of the moon is just right, THEN you **MIGHT**
get an ordered set.

In fact, that's pretty much guaranteed to work, right up
until you're demo'ing your project for the clients.