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.