Information générale
Forum:
Microsoft SQL Server
>AFAIK, there's not a recno() style row-level variable in SQL Server. You may need to rethink approaches to this. Try a TOP X Clause with a specific order (maybe a "tModify" - style date of update, or an identity column).
There really isn't one. Shame. Anyway, the MSSQL table is recreated every night with a DTS job (it's a reference table, no inserts/updates on it hroughout the day). I added an alter table statement to the end of the DTS job to add an identity (sequential integer) column on the end. Now I can get the date for VFP in gulps, specifying the identity value as a parameter.
Thanks!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement