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
No comments:
Post a Comment