Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
>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
Stephen,
The SQL tools (QA, EM, and SSMS) do not include a cursor browser. What you can do is place a 'select * from temptable' command into the procedure or script immediately before the OPEN CURSOR command to see the same result set that the cursor will use. In QA or SSMS the result set will be displayed in the results pane and you can scroll through it.
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