Ankit Singh
Total Post:341
Points:2389
I want to use Exception Handling in SQL Server please help me.
Total Post:341
Points:2389© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved
Post:281
Points:2003Re: SQL Server Exception Handling
QL Server also has an exception model to handle exceptions and errors that occurs in T-SQL statements. To handle exception in Sql Server we have TRY..CATCH blocks. We put T-SQL statements in TRY block and to handle exception we write code in CATCH block. If there is an error in code within TRY block then the control will automatically jump to the corresponding CATCH blocks.The TRY...CATCH statement which helps us to handle the errors effectively in the back end. This handling of the exception can provide additional information about the errors.