Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Browsing the results of a cursor in a stored procedure
Message
 
 
À
20/12/2006 11:11:43
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01179225
Message ID:
01179237
Vues:
10
>Is there any way that I can browse the results of a cursor in a stored procedure. I am using Declare temp_Cursor CURSOR SCROLL FOR select * from temptable
>then after the cursor is executed I would like to browse the result set so I can make sure the data is accurate.

A data in a cursor can anly be accessed with FETCH command. See Re: USE command in SP Message #1057625 for an alternatrive method of processing records.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform