I have created an index on fld_Description to prevent duplicate records.
When I open the table in Management Studio Express, the data in the table is sorted by fld_Description. What I would like to see when I open the table is to see the data sorted by PK_fldID. Is this possible?
To guarantee the sorting of how the data is shown in Management Studio or in any SELECT statement you issue, you must always provide the ORDER BY clause. If there's no ORDER BY clause in your SELECT statement, the sorting of the data will be in the order SQL Server retrieved the data. The data may be in memory or it may be retrieved from the data files but the order may not always be in the same sorting every time you view the data in Management Studio. Just remember that in Management Studio, it simply sends out a SELECT statement just the same way you would type it manually.
Table Sorting
Posted - 06/06/2009 : 13:43:11
