Paste in with select * select does not work

Question

If tables A and B have the same structure (except for the ID field). In A, it is assigned automatically, but in B it expects a value from the insert.

How can I do INSERT INTO A (select * from B).

What is the fastest, most flexible SQL that can work in a stored procedure.

Answer 1

Specify the columns explicitly:

INSERT INTO TableA (col1, col2) SELECT col1, col2 FROM TableB