t-sql select by row number

[Mostafa Nabil]

I am making a program which selects a row from a database based on its row number, who can i do that using a sored procedure?

I googled about it a lot but I found nothing

[amtrac24]

are you using sql server 2005?

SELECT
RecordID,
RecordName,
Row_Number() Over (Order By RecordName ASC) AS ROWID

FROM MyTable
ORDER BY RecordID ASC;