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:
01181604
Vues:
8
>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.
>
>Thanks for you help !
>Stephen J. Hunt

You could by fetch line write the contents to another #Temp table and view it.

But no not really.

You know that you should avoid cursors at all costs don't you? ;0
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform