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).
>
--sb--