You can add integer field with IDENTITY attribute.

>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