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 |
|
David Wadsworth
Starting Member
17 Posts |
 Posted - 2009-10-23 : 05:30:05
|
| Hi Everyone,A quickie (I hope) ... upon opening SQL Server management (2005) and opening one of my tables I notice that the data is not in the usual order on the screen. I have an identity column 0,1,2 ... and in all other tables the data is ordered by this number but in just one table the data orders thus 52,53,54,16,17,18,55,56 .... it this corruption or normal. The database is working fine and I cannot fault the system, its just the first time I have seen it.I tried a Google search but was seemingly unable to choose the correct key words.TIA |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-23 : 05:58:39
|
All OK!There is no reliable order in sql server tables.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-23 : 06:08:40
|
| If you want a defined order for rows, use the ORDER BY clause. Without that you're asking SQL to return the rows and allowing it to decide what order to return them in.--Gail ShawSQL Server MVP |
|
|
|
David Wadsworth
Starting Member
17 Posts |
Posted - 2009-11-11 : 04:37:39
|
| Thanks everyone ... |
|
|
|
|
|
|
|
|
Corruption??