Exception Handling in SQL SERVER
Exception Handling is a practice to capture the error efficiently and display the error in a well formatted way.
In SQL Server, we use the TRY..CATCH Block for handling exceptions.
The syntax is as follows
BEGIN TRY
{ sql_statement | statement_block }
END TRY
BEGIN CATCH
[ { sql_statement | statement_block } ]
END CATCH
[ ; ]
The below shows an exception message for divide by zero error
CREATE PROCEDURE GenerateException
AS
BEGIN
BEGIN TRY
SELECT 1/0
END TRY
BEGIN CATCH
SELECT 'Error Occurred'
END CATCH
END