Syntax for INSERT INTO vs SELECT INTO

One is commonly confused for the other….so …. SELECT INTO inserts data into a new table and creates the new table on the fly (Table doesn’t exist) … INSERT INTO inserts data into an existing table … Reference from┬áPinal Dave.