SqlServer 序号列的实现方法

SELECT [AUTOID] = IDENTITY(int,1,1), * INTO #temp_table FROM 表名;

SELECT * FROM #temp_table;

SELECT *,ROW_NUMBER() OVER (ORDER BY 排序字段) AS [AUTOID] FROM 表名;