Exception Handling (using Try-Catch) in SQL Statement!

Generally, we use try-catch block in frontend code behind to handle exception, even we try to catch error which occurred at SQL statement. We can easily catch/handle the error at SQL statement, it’s really very easy and good approach to handle EXCEPTION
at SQL statement (it may be in stored procedure or in trigger or in function or in view etc.)