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