Using SQL Server 2005 new function ROW_NUMBER() makes this really easy.
All you have to do is to add the function ROW_NUMBER, with the OVER() clause as such :
OVER (ORDER BY EmployeeName) AS Row,
EmployeeId, EmployeeName, Salary
The OVER clause needs an “order by” parameter to know how to sort the rows for proper numbering.
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in any way.