While the row_number feature in sql 2005+ has proven to be a very powerful feature, there are still ways to implement that same functionality in SQL Server 2000. Let’s first look at the SQL 2005+ implementation of ROW_NUMBER, then compare it to the SQL 2000: — SQL 2005+ SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY [...]
Archive of posts filed under the SQL Server 2000 category.
