Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Same SELECT with different order
Message
From
27/11/2009 17:22:37
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01436778
Message ID:
01436784
Views:
38
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).
>>
Previous
Reply
Map
View

Click here to load this message in the networking platform