SQL table is not in order

[TechnicalScott]

Sorry for cross posting

Hello,

I have an SQL database which is read by an access front end. I've been browsing through the records and have discovered that the SQL table isn't in order anymore, it jumps every now and again so I end up with a sequence such as 500, 501, 502, 580, 581, 582, 503, 504

Any ideas how I get it back on track?

Regards

Scott

 

[JohnDTampaBay]

Rows are not retrieved from SQL databases in any particular order unless you specify ORDER BY in the select statement. The CLUSTERED index determines what order records are stored in the table. Rebuilding the index may help the appearance that rows are out of order, but in truth there is no order at all.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)