471,873 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

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 1253

"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
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.