Implementation method of SQL Server ordinal column _mssql

For SQL SERVER 2000 and earlier versions, you need to use a self-added column, which is implemented in conjunction with temporary tables.

Copy Code code as follows:

SELECT [Autoid] = IDENTITY (int,1,1), * into #temp_table the from table name;

Copy Code code as follows:

SELECT * from #temp_table;

Starting with SQL Server 2005, SQL Server provides a row_number () function that greatly simplifies the work.

Copy Code code as follows:

SELECT *,row_number () over (ordered by sort field) as [autoid] from table name;

An alias for an ordinal field that can be used in subsequent conditions.