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
Error Handling in SQL Server – a Background & Implementing Error Handling with Stored Procedures A bible for SQL Server error handling....