IDENTITY

--(1)
SELECT ID_Num =IDENTITY(int, 1,1)INTO NewTable FROM Brand_Brand
select * from NewTable
--(2)
SELECT ID_Num = IDENTITY(int, 1, 1)INTO NewTable FROM OldTable
select * from NewTable2