SELECT ROW_NUMBER() OVER (ORDER BY a) AS Row, EmployeeId, EmployeeName, Salary FROM Employees
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)