Exception Handling with TRY, CATCH, and THROW

1.0https://www.w3computing.com/sqlserver2012w3compadminhttps://www.w3computing.com/sqlserver2012/author/w3compadmin/Exception Handling with TRY, CATCH, and THROW - SQL Serverrich600338<blockquote class="wp-embedded-content" data-secret="IgvH6bQP7Y"><a href="https://www.w3computing.com/sqlserver2012/exception-handling-try-catch-throw/">Exception Handling with TRY, CATCH, and THROW</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.w3computing.com/sqlserver2012/exception-handling-try-catch-throw/embed/#?secret=IgvH6bQP7Y" width="600" height="338" title="“Exception Handling with TRY, CATCH, and THROW” — " data-secret="IgvH6bQP7Y" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://www.w3computing.com/sqlserver2012/wp-includes/js/wp-embed.min.js </script> Starting with SQL Server 2005, you can capture and handle exceptions using two statements, TRY and CATCH. This section first explains what exception means and then discusses how these two statements work. An exception is a problem (usually an error) that prevents the continuation of a program.