title: How to determine in-script if a SQL statement failed
body: <p>I am  currently typing a script for a project of mine and currently having difficulties finding information on how to do most of the functionality MS SQL has to offer. </p>
  
  <p>I am trying to figure out a way to test if an SQL statement failed its execution. For example, making an attempt to insert a record that already exists in the table. Any help would be greatly appreciated</p>