I need to update a sql server table with the number of each record in a field called recnbr

In vfp it would be

select mytable

update reccnbr with recno()

What would be the t-sql equivalent of recno() ?

IOW, knowing that _there is no_ recno() function in t-sql, what would be the update statement like?

TIA

Rafael Copquin

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---