Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2008-06-26 : 07:22:41
|
| How does SQL Server display results of a query if you don't specify any order by clause? Like the order the data added to the table? Or something else? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-26 : 07:28:21
|
| That depends on lots of a factors like presence of clustered index, way table is organised etc... But unless you specify the order explicitly by means of ORDER BY clause you can never guarantee the order in which data is retrived. |
 |
|
|
|
|
|
How does SQL Server order results