Hi. How I can order a table by a field permanently?

[omauri]

Hi. I need to order a table by a field permanently, whenever I enter a new data in this table. Thanks.

 

[fluteplr]

At the risk of being flippant. Why, you can't really control how sql server is going to store the data. If you need it sorted in a particular order when you retrieve it do that then. If you are trying to optimize certain retrievals than look up clustered indexes.

 

[shyamMelwani]

hi,

I think may be you should consider having a 'Clustered Index' on this field. That way the data could be ordered and stored in the table. What's more it also maintains an index.