RE: recno() function in t-sql

Have a look at SELECT ROW_NUMBER() OVER(.....) AS Recnbr,x,y,z

-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Rafael Copquin Sent: Thursday, 5 July 2018 5:30 AM To: profoxtech@leafe.com Subject: 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 ---

[excessive quoting removed by server]