The best replacement for select into is insert into.

The best alternatives to select into are rated as following:
★★★★★  insert into
★★  create table
★  insert
★  bulk insert
★  insert select
★  create
★  cursor
★  insert into select
  cursor oracle

Your alternative for select into is not listed? Suggest!
Speaking about select into, one probably shouldn't forget about identity.

Other search terms related to select into and their ratings are:
★★★★★ identity
★★ identity column
★ creating new table
You have in mind a companion for select into and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of select into in all years. Click on graph for more.
select into
insert into
create table