Rownum in SQL Server - SQL Server Planet

2010年6月13日 - Prior to SQL Server 2005, there was no inherent function to generate a rownumber within a row. There is a workaround however for SQL 2000.

sqlserverplanet.com