create a new table from select statement sql server code example

Example 1: sqlserver create table from select

Select * into new_table  from  old_table

Example 2: select new table sql

SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;