Is it possible to have 2x Cursors and 2x @@FETCH_STATUS = 0 in one Stored Procedure?
From: Andreas Klemt (aklemt68_at_hotmail.com)
Date: 04/12/04
- Next message: Dan Guzman: "Re: Drop Database Error"
- Previous message: Dan Guzman: "Re: recover mode and the transaction log file question"
- Next in thread: Dan Guzman: "Re: Is it possible to have 2x Cursors and 2x @@FETCH_STATUS = 0 in one Stored Procedure?"
- Reply: Dan Guzman: "Re: Is it possible to have 2x Cursors and 2x @@FETCH_STATUS = 0 in one Stored Procedure?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 12 Apr 2004 03:49:44 +0200
Hello,
I have a Stored Procedure and I want to use
2x Cursors with different Name and I have 2x
WHILE @@FETCH_STATUS = 0
Is this ok or is there a better solution. I need to use at least
two Cursors in my Stored Procedure.
Thanks for any help in advance!!
Andreas
- Next message: Dan Guzman: "Re: Drop Database Error"
- Previous message: Dan Guzman: "Re: recover mode and the transaction log file question"
- Next in thread: Dan Guzman: "Re: Is it possible to have 2x Cursors and 2x @@FETCH_STATUS = 0 in one Stored Procedure?"
- Reply: Dan Guzman: "Re: Is it possible to have 2x Cursors and 2x @@FETCH_STATUS = 0 in one Stored Procedure?"
- Messages sorted by: [ date ] [ thread ]