Dotnetindex.com

When-using-the-following-SQL-statement-the-error-2117-Unexpected-extra-token-is-returned

When using the following SQL statement the error 2117 (Unexpected extra token) is returned.

INSERT INTO TableA
SELECT *
FROM Tableb
ORDER BY Field1;

An Order By clause is illegal in an SQL INSERT INTO statement.

By default a table is a set of unordered rows. With ADT tables this is especially true due to record recycling. When a row is marked for deletion the physical row is not removed from the table but is marked as "free". During an INSERT statement any rows that are marked as free will be used first. Due to this behavior rows may be inserted into the table at odd location. Rather then inserting the rows in a specific order it is best to retreive the rows in a specific order using the ORDER BY clause in a SELECT statement.