General information
Forum:
Microsoft SQL Server
Environment versions
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).
>>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only