-
Cursors:
Hi:
Here is a scenario and I need to know where is the best place to put a begin transaction in a stored procedure:
I have just put some steps of execution below. I would like to rollback any changes made by the inside stored proc but move on to the next fetch from the outside cursor. I am just not sure where I need to place the begin transaction in the inside cursor and outside cursor. Please advise
Bulk insert
Open cursor
--inside stored proc
Call to another stored procedure
for update (this stored proc has a
cursor within it)
Cursor close
Bulk Update
Thanks in advance
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
|
|