Has SELECT an INSERT clause?
Both posts are wrong syntax.
I've -1 in the first from SO and left a comment on the second.
Create a table
SELECT * INTO PlayerBackups FROM NhlPlayer
Inserts to an existing table
INSERT PlayerBackups SELECT * FROM PlayerBackups
SELECT *
INTO new_table
FROM old_table
The above creates a new table based off of the source's table structure. new_table, in this example, cannot exist or an error will be raised and the statement will not be committed.
INSERT INTO new_table_must_exist
SELECT *
FROM old_table
In this example, it copies data from old_table to new_table_must_exist. Here new_table_must_exist must already exist, and the data mappings have to be compatible.