--(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
转载于:https://www.cnblogs.com/wyxy2005/archive/2010/05/18/1738228.html