Exceptional Handling In SQL Server:
Error or
exception handling in sql server is easy task. In Sql server we can find the
error using TRY CATCH statement, which helps us to find the error effectively
in the back end. Exceptional handling provides additional information about the
errors such as Error Message, Error Line, Error Number etc.
We put Sql
statement in TRY block and to handle error we write code in CATCH block. If
error occurs in try block then control automatically goes to CATCH block.
