How to create a try catch in SQL Server

[Z12]

To create a try / catch in SQL Server:

Code: Select all

BEGIN TRY  
    -- Generate divide-by-zero error.  
    SELECT 1/0 
END TRY

BEGIN CATCH  
	SELECT ERROR_NUMBER() AS ErrorNumber,
		ERROR_SEVERITY() AS ErrorSeverity,
		ERROR_STATE() AS ErrorState,
		ERROR_PROCEDURE() AS ErrorProcedure,
		ERROR_LINE() AS ErrorLine,
		ERROR_MESSAGE() AS ErrorMessage
END CATCH