Blogs about: Sql Server 20002005 Row Number
Featured Blog
Create Serial Number Column using SQL Server
this is only for SQL 2005 SELECT CategoryID, CategoryName FROM (SELECT Row_Number() OVER(ORDER BY CategoryName DESC) as RowNum, CategoryID, CategoryName FROM dbo.Categ… more →
Jwalin Khatri
Create Serial Number Column using SQL Server
jwalin wrote 10 months ago: this is only for SQL 2005 SELECT CategoryID, CategoryName FROM (SELECT Row_Number() OVER(ORDER B … more →
