利用"SQL"语句自动生成序号的两种方式

select row_number() over (order by name) as rowid, sysobjects.[name] from sysobjects

rowid   name
1           all_columns
2           all_objects
3           all_parameters
4           all_sql_modules
5           all_views

select id=IDENTITY(int,1,1), sysobjects.[name] as name into dbo.Test_Table from sysobjects