How to get Row Number with the result of SQL select query

How to get Row Number with the result of SQL select query?
Row Number concept not available in SQL Server 2000.its introduced in SQL Server 2005.
The syntax of Row Number is

ROW_NUMBER () OVER ([] )

Example of Row Number is

SELECT ROW_NUMBER() OVER (ORDER BY FieldName ASC) AS ROWNO, * FROM Table_Name