Returning a result with incremented rows in MS SQL Server 2008

How do I return a row and an ascendi开发者_如何学JAVAng counter as a result set?

---

It depends on your RDMS, but there's probably a RANK or ROW_NUMBER function.

---

If its SQL Server you can do it with the following syntax:

SELECT     ROW_NUMBER() OVER (ORDER BY COLUMN_NAME) AS Id, column1, column2, ....