"Jim" <ji********@motorola.com> wrote in message
news:72**************************@posting.google.c om...
I put a clustered index on a table with 2 columns
-nationalityid int autoincrement PK
-nationality varchar(50)
the clustered index is on nationality
however; when i do a select i still get a record set back ordered by
the nationality id...what am I doing wrong?
-Jim
When you do a SELECT, you must specify ORDER BY if you want the result set
to be in a certain order. Even with a clustered index on a table, there is
no guarantee that you will get your results in any specific order.
Simon