|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 1st, 2005, 02:45 AM
|
||||
|
||||
|
Stored Procedure results into cursor?
Is it possible to put the returned record set of a stored procedure into a cursor.
I have dynamically created a sql statement which is being executed by the EXEC sp_executeSQL, but I wish to put the results into a cursor so that I can scroll through them. It is possible to insert the results into a temporary table, but being able to put them in a cursor would save me some work.
|
|
#2
February 1st, 2005, 12:44 PM
|
||||
|
||||
|
Why not just do it all in one stored procedure?
1) Select the records 2) Open the cursor 3) Loop through the records
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Stored Procedure results into cursor? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
