Sql Query Create a new Table

Question

Can anyone offered syntax for a sql query that takes an already created table and inserts some of the data into a new table with a new id(primary key)? So far I tried this

SELECT ((ID INT IDENTITY(1,1) PRIMARY KEY), column1, column2, column3)
INTO table_name
FROM table_name 

I keep coming up with a syntax error.

Answer 1

SELECT column1, column2, column3
INTO table_name_new
FROM table_name_old

use like this

Answer 2

INSERT INTO newtable (column1, column2, column3)
SELECT (column1, column2, column3) 
FROM table_name