-
Getting storedprocedures results into Cursors
hi,
How can i get system stored procedure resultset into cursors.
example:
I want to get sp_validatelogin result set into curosors.
How??????????
thanks
keerthi
-
Getting storedprocedures results into Cursors (reply)
The only way I can think of doing something like this is to get the results of sp_validatelogin into a temp table and then declare the cursor on the table.
e.g.
INSERT INTO #MyTemp EXEC('sp_validatelogin'
DECLARE MyTemp_Cursor CURSOR FOR
SELECT ... FROM #MyTemp
...
...
...
You will need to create the temp table before hand with the specific columns that match the output of your stored procedure.
Hope that helps,
Karl
------------
keerthi at 9/5/01 2:42:23 PM
hi,
How can i get system stored procedure resultset into cursors.
example:
I want to get sp_validatelogin result set into curosors.
How??????????
thanks
keerthi
-
Getting storedprocedures results into Cursors (reply)
Hi Karl,
It worked for me.
Thank you
Keerthi
------------
keerthi at 9/5/01 2:42:23 PM
hi,
How can i get system stored procedure resultset into cursors.
example:
I want to get sp_validatelogin result set into curosors.
How??????????
thanks
keerthi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|