|
|
Posted by Eric J. Holtman on 05/27/06 21:58
"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.
Navigation:
[Reply to this message]
|