Get RowNumber() for table in sqlserver 2000 | The ASP.NET Forums

I want the rownumber over Id column and succeeded in getting the required ... Could any one give me the query in Sql server 2000 which is ...

forums.asp.net