SQL Server Performance

Exception Handling in stored procedure

Discussion in 'General Developer Questions' started by query4u, Jun 5, 2009.

  1. query4u New Member

    Hi,
    I have created one stored procedure in which i have written a cursor in which i am fetching some records. on the basis of value(suppose transaction_id) which i get in cursor i am doing some operations like updations/insertion etc. if any error come while updation/insertion for particular record it comes out of cursor loop & for next records i could not perform any operations like updations/insertion. can anybody suggest how i should handle an exception so that if any error comes in loop for any record if should move further for next records for performing the operation.
    Thanks in advance
  2. satya Moderator

Share This Page