If table has clustered index than records will be returned in its order, otherwise record order is unpredictible.

>I just noticed that the newly added records are somewhere in the middle of the table, not at the end. Why? In what order does Enterprise Manage show the records when you open a table?