Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Index order
Message
 
 
To
27/02/2006 10:05:19
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01099434
Message ID:
01099444
Views:
18
>I have a SQL Server table that has 7 indexes defined. When I do a simple select
>statement from the query analyzer without using ORDER BY the results of the query come back in the order of the 4th index defined. Is there a way to define
>an index as primary in SQL server either with a command or using the enterprise manager ?

Only ORDER BY can guaranty the order of the records in the result set.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform