Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Function @@CURSOR_ROWS
Message
De
18/11/1999 17:00:11
 
 
À
18/11/1999 16:28:49
Dave Sonier
Technologies Nter inc.
Gatineau, Québec, Canada
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00292723
Message ID:
00292745
Vues:
35
>How does work the function @@cursor_rows ???

@@CURSOR_ROWS return the number of rows in the cursor. The reason that you're getting a -1 is because a dynamic cursor was created. From the SQL BOL:

(-1) The cursor is dynamic. Because dynamic cursors reflect all changes, the number of rows that qualify for the cursor is constantly changing. It can never be definitely stated that all qualified rows have been retrieved.

To get the results that you're looking for, add the INSENSITIVE clause:

declare dave INSENSITIVE cursor for
select * from syst_msg

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform