I searched the internet and found an alternative answer that works
DECLARE @id INT
SET @id = 0
UPDATE mybase.dbo.invoices
SET @id = recnbr = @id + 1
GO
The above filled the recnbr column with a sequence of numbers starting
with 1 incrementing by 1, which was my purpose
Thnaks again
Rafael
El 05/07/2018 a las 9:13, Rafael Copquin escribió:
Thank you
El mié., 4 de jul. de 2018 17:29, Darren <[email protected]
<mailto:[email protected]>> escribió:
Have a look at SELECT ROW_NUMBER() OVER(.....) AS Recnbr,x,y,z
-----Original Message-----
From: ProfoxTech [mailto:[email protected]
<mailto:[email protected]>] On Behalf Of Rafael
Copquin
Sent: Thursday, 5 July 2018 5:30 AM
To: [email protected] <mailto:[email protected]>
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]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
