Re: Insert a record in a particular place

"Ralph Ganszky" <rg@xxxxxx> wrote in news:e59adc$kug$01$1@xxxxxxx
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.

.