Using TRY and CATCH Blocks in T-SQL

Using TRY and CATCH Blocks in T-SQL

You can handle errors in T-SQL almost the same way as in C# or Visual Basic. You can make use of a Try and catch block to trap errors and provide feedback on the error.

A small example follows:

BEGIN TRY    SELECT *        FROM TABLE        WHERE Name LIKE '%Hannes%'END TRYBEGIN CATCHSELECT         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 

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist