SQL SERVER – Insert Data From One Table to Another Table

Query for Selected Columns 

SELECT Col1,col2
INTO Table_New
FROM Table_Original  

 Query For  All Columns 

SELECT *
INTO Table_New
FROM Table_Original  

Query For All Columns With Where Condition

SELECT *
INTO Table_New
FROM Table_Original where <Condition>