SELECT row_number() Over (Order by dbo_M_City.CityID) as [Sno],dbo_M_City.CityID, dbo_M_City.CityName FROM dbo_M_City;
SELECT row_number() Over (Order by CityID) as [Sno],CityID, CityName FROM dbo.M_City
SELECT ROW_NUMBER() OVER (ORDER BY CITYID) as [SNO], CITYID, CITYNAME FROM dbo.M_CITY;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)