Implementing Error Handling with Stored Procedures

(Erland Sommarskog) Error handling in stored procedures is a very tedious task, because T-SQL offers no exception mechanism, or any On Error Goto. All you have is the global variable @@error which you need to check after each statement for a non-zero value to be perfectly safe. If you call a stored

Read More - Register for Free Membership