SQL table 'out of order'

[TechnicalScott]

Hi all,

How do I put my SQL table back into primary key order, it appears to have thrown a wobbler and put some of the entries in any order.

Cheers

 

[SQLDenis]

You should not rely on that, the order of the table is never guaranteed even if you were to rebuild your index
Use order by in your select statements instead

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/