records sequences

[inusrat]

Hi,

I am using MSDE. I see in my table my records are order by my primary key. I am wodering is it possible that you have records in your table in the sequences in which they get inserted?

Thanks

 

[cmmrfrds]

You can get any order you want with a select statement that has an order by clause.

 

[inusrat]

thanks for your reply. I actualy want to sequence the records in the table. When I reterive the rcords I know i can use the order clause in select statment.

 

[cmmrfrds]

Use a clustered index on any field or combination of fields, at least this works in sql server.