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

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

rowid   name1           all_columns2           all_objects3           all_parameters4           all_sql_modules5           all_views

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