Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2008
Thanks!
The info of no concept of deafult order explains it.
>There's no concept of default order for a table in SQL Server. A result of a query w/o ORDER BY clause is not guaranteed to be in any particular order. IOW, use ORDER BY clause to get order you want/need.
>
>>Hi, a have a doubt about the SELECT Clause in SQL Server with unique key indexes and the result of data, and why a difrent result with the same SELECT clause.
>>
>>I have 2 tables, the scrip follows:
>>1º table
>< snip >
>>
>>Select in both tables:
>>
>>select * from dbo.Teste1
>>select * from dbo.Teste2
>>
>>What I want to know is Why in the first table with the select clause the result was ordered bay the "descricao" column, and why in the second select the result of the same SELECT command was returned in order the data was inserted,(no order).
>>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement