Friday, September 30, 2011

Row Number Generator in SQL Server

SELECT row_number() over (ORDER BY donorid) as SLNo, *
FROM BloodDonorDB.dbo.DonorData

No comments:

Post a Comment