Just a quick theory question. Say I periodically insert some records into a non-indexed table. I assume that records will be added to the end of the table? So, when I retrieve the rows with a simple Select query, am I guaranteed that all the records will be displayed in the same order that they were inserted? Is this rule supported by SQL server?>> "am I guaranteed that all the records will be displayed
>> in the same order that they were inserted?"
no
if you want sequence, use ORDER BY
rudy
Showing posts with label non-indexed. Show all posts
Showing posts with label non-indexed. Show all posts
Subscribe to:
Posts (Atom)