How to Implement SQL Server serial number Columns

For SQL SERVER 2000 and earlier versions, you must use an auto-incrementing column and a temporary table.
Copy codeThe Code is as follows:
SELECT [AUTOID] = IDENTITY (int, 1, 1), * INTO # temp_table FROM table name;


Copy codeThe Code is as follows:
SELECT * FROM # temp_table;

Since SQL server 2005, SQL SERVER provides a ROW_NUMBER () function, which greatly simplifies the work.

Copy codeThe Code is as follows:
SELECT *, ROW_NUMBER () OVER (order by sorting field) AS [AUTOID] FROM table name;

The alias of the serial number field, which can be used in subsequent conditions.