{"id":80,"date":"2012-08-20T19:51:00","date_gmt":"2012-08-21T00:51:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=80"},"modified":"2023-07-26T12:38:29","modified_gmt":"2023-07-26T17:38:29","slug":"sql-server-generic-try-catch-snippet","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=80","title":{"rendered":"SQL Server:  Generic Try\/Catch Snippet"},"content":{"rendered":"<p><span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">BEGIN TRY<\/span><\/p>\n<p><span style=\"color: #38761d; font-family: &quot;Courier New&quot;, Courier, monospace;\">&#8212; do stuff<\/span><\/p>\n<p><span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">END TRY<\/span><\/p>\n<p><span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">BEGIN CATCH<\/span><\/p>\n<p><span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECLARE @PROC AS VARCHAR(100)<\/span><br \/>\n<span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECLARE @SERVER AS VARCHAR(200)<\/span><br \/>\n<span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECLARE @ERROR AS VARCHAR(4000)<\/span><\/p>\n<p><span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT @PROC = <span style=\"color: magenta;\">ERROR_PROCEDURE<\/span>(), <\/span><br \/>\n<span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @SERVER = <span style=\"color: magenta;\">@@SERVERNAME<\/span>, <\/span><br \/>\n<span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @ERROR = <span style=\"color: magenta;\">ERROR_MESSAGE<\/span>();<\/span><\/p>\n<p><span style=\"color: blue; font-family: &quot;Courier New&quot;, Courier, monospace;\">END CATCH;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>BEGIN TRY &#8212; do stuff END TRY BEGIN CATCH &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECLARE @PROC AS VARCHAR(100) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECLARE @SERVER AS VARCHAR(200) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECLARE @ERROR AS VARCHAR(4000) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT @PROC = ERROR_PROCEDURE(), &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @SERVER = @@SERVERNAME, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @ERROR = ERROR_MESSAGE(); END CATCH;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[50],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/80"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=80"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions"}],"predecessor-version":[{"id":196,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions\/196"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}