復制代碼 代碼如下:

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

復制代碼 代碼如下:

SELECT * FROM #temp_table;

復制代碼 代碼如下:

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