Identity In temp Table

Insert data into table with identity column

This query is used to INSERT identity column into tamp table

SELECT IDENTITY(INT, 1 , 1) AS ID,  COLUMN1 , COLUMN2

INTO #TABLE1

FROM dbo.TABLE2;