sql server create from select 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: sql create table with columns as another table
SELECT * INTO newtable FROM oldtable WHERE 1 = 0;