1.select row_number() over (order by name) as rowid, sysobjects.[name] from sysobjects2.select id=IDENTITY(int,1,1), sysobjects.[name] as name into dbo.Test_Table from sysobjects
