CREATE TABLE #Temp ( Id int Identity(1,1), Name nvarchar(100) ) INSERT INTO #Temp(Name) VALUES('SANDEEP'),('RAVIENDER') SELECT Name, ROW_NUMBER() OVER(ORDER BY Name) AS ROW From #Temp DROP TABLE #Temp
SELECT ROW_NUMBER() OVER (ORDER BY a) AS Row, EmployeeId, EmployeeName, Salary FROM Employees
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)