http://www.openwinforms.com/row_number_to_sql_select.html
http://www.sqlusa.com/bestpractices2005/addrownumbertotable/
SELECT ROW_NUMBER()
OVER (ORDER BY EmployeeName) AS Row,
EmployeeId, EmployeeName, Salary
FROM Employees
http://www.openwinforms.com/row_number_to_sql_select.html
http://www.sqlusa.com/bestpractices2005/addrownumbertotable/
SELECT ROW_NUMBER()
OVER (ORDER BY EmployeeName) AS Row,
EmployeeId, EmployeeName, Salary
FROM Employees