Would I be correct in thinking that if you omit an ORDER BY clause when querying a Table variable in TSQL that you cannot guarantee the order in which the resulting records will be returned? That is, the Query Optimizer treats them the same as a normal user table.

For example, the output from the following TSQL would not guarantee a result set ordered by Col1:

--Insert into a table variable in order of Column 1, asceding.INSERT @aTableSELECT Col1, Col2, Col3FROM anotherTableORDER BY Col1

--Select from the table variable with no ORDER BY clause.SELECT *FROM @aTable