What is the way to receive the data as we entered

[Raghuraman]

Hai ,

I created a table with primary key clustered. I have entered the data
thru E.Manager . If a close the table and open it again , Ii shows the
rows with the (default) ascending order. Is, there any way to get the
rows in the user entered order(neither asc or dec order)
With Thanks
Raghu

[Greg D. Moore \(Strider\)]

"Raghuraman" <ra************@rediffmail.com> wrote in message
news:66**************************@posting.google.c om...

Hai ,

I created a table with primary key clustered. I have entered the data
thru E.Manager . If a close the table and open it again , Ii shows the
rows with the (default) ascending order. Is, there any way to get the
rows in the user entered order(neither asc or dec order)
I don't believe so.

Keep in mind that in theory there is no "order" to the way the data is
stored. So the order it was entered is meaningless.

The only way to guarantee the order of output is with an order by statement.
And I don't think you can force that in EM.



With Thanks
Raghu

[Nigel Rivett]

No. A clustered index physically orders the data.
Even without the index it would not be possible unless design for it -
as Greg D. Moore says tables have no inherent order.

You would need to add an identity or timestamp column and order by
that.