create table from select sql server code example
Example 1: SELECT INTO
SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
FROM nome_da_tabela_que_estao_a_mexer
Example 2: sqlserver create table from select
Select * into new_table from old_table
Example 3: sql create table with columns as another table
SELECT * INTO newtable FROM oldtable WHERE 1 = 0;