During the pre-SQL Server 2005 days, we had to handle errors via transactions. At times, this could prove challenging when dealing with specific errors. Some might fall through making debugging difficult.<\/p>\n
Fortunately, the team at Microsoft copied the try\/catch approach from Visual Studio to SQL Server.<\/p>\n
Here is the deprecated approach:<\/p>\n
BEGIN TRANSACTION<\/p>\n DELETE FROM tblBlah Here is the current best practice:<\/p>\n BEGIN TRY DELETE FROM dbo.tblBlah END CATCH<\/span><\/p>\n","protected":false},"excerpt":{"rendered":" During the pre-SQL Server 2005 days, we had to handle errors via transactions. At times, this could prove challenging when dealing with specific errors. Some might fall through making debugging difficult. Fortunately, the team at Microsoft copied the try\/catch approach from Visual Studio to SQL Server. Here is the deprecated approach: BEGIN TRANSACTION DELETE FROM … Continue reading “SQL Error Handling”<\/span><\/a><\/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":[55],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/112"}],"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=112"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/112\/revisions"}],"predecessor-version":[{"id":183,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/112\/revisions\/183"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
WHERE DATESENT <= @DATE IF @@ERROR = 0 COMMIT TRANSACTION ELSE ROLLBACK TRANSACTION<\/span><\/p>\n
BEGIN TRANSACTION<\/p>\n
WHERE DATESENT <= @DATE COMMIT TRANSACTION END TRY BEGIN CATCH IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION<\/p>\n