I need to order a temp table (#Temp) by a field1 and using a consecutive number 1,2,3... for each record.

In VFP is very easy using RecNo(), but I don't know how to do in Sql-Server

TIA