The syntax looks like this:
BEGIN TRY “Your code goes here” END TRY BEGIN CATCH “Your error condition code goes here” END CATCH
What happens when TRY/CATCH block implemented. Let’s go into the details. Whatever code you are writing inside the try block will get executed by default. When an error occurred for the code which is inside the try block it will stop execution and jump to catch block and run the code which you had written for handling the error, just like the traditional method of error handling. One thing we need to notice here is that there are different error level types. 0 - 10 are Warnings, 11 - 19 are Trappable Errors and 20 - 25 are Terminal Errors.
SQL Server 2005 had dished out some additional functions also to make our job easy. Let’s check out some of the important functions among them and what they returns.
- ERROR_NUMBER() – Show you the error number. You can find all error numbers and descriptions in sysmessages table.
- ERROR_MESSAGE() – Shows the readable description of the error.
- ERROR_LINE() – Returns the line number from where error thrown.
- ERROR_SEVERITY() – Will show up error levels.
- ERROR_STATE() – Shows what kind of error it’s. Example 1 for system errors
- ERROR_PROCEDURE() – This gives you the procedure name which causes the error.
With all these I hope error handling got much easier. Enjoy implementing these.