Last Updated: February 25, 2016
·
330
· acemtrace

Exception Handling in SQL Server

exception handling in SQL Server 2008 is:

BEGIN TRY
<br>
-- queries and stuff
<br>
END TRY
<br>
BEGIN CATCH
<br>
-- (optional) things to do when exception occurs
<br>
END CATCH

the CATCH can be empty, if you do not need to add something to it.