Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understanding indexing?
Message
De
25/08/2009 08:16:25
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01420204
Message ID:
01420418
Vues:
34
>>SQL server adds an "order by" clause by select first field of query...
>
>From the SQL server documentation: "If the query includes an ORDER BY clause, the first expression rows, or expression percent of rows, ordered by the ORDER BY clause are returned. If the query has no ORDER BY clause, the order of the rows is arbitrary."
>
>(http://msdn.microsoft.com/en-us/library/ms189463.aspx)

that's confirm me. sql server add's an order arbitrary... :)

Note:
I didn't know it can be possible use top without order until saw Daniel's message. But I tried and saw results. Look my answer to Cetin.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform