recno() function in t-sql

What is the equivalent of therecno() function in t-sql

I need to fill a column called recnbr with the record number of each line

In VFP it would be:

update mytable set recnbr = recno()

But since there is no recno() function in t-sql, what would be a replacement?

TIA

Rafael Copquin

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