469,090 Members | 1,124 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

What is the way to receive the data as we entered

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
Jul 20 '05 #1
2 1218

"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

Jul 20 '05 #2
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.
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Sathesh Arumugam | last post: by
reply views Thread by ?lafur Helgi R?gnvaldsson | last post: by
reply views Thread by Shoveler | last post: by
5 posts views Thread by Ole | last post: by
3 posts views Thread by Joe Blauth | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.