title: SQL Server BEGIN/END vs BEGIN TRANS/COMMIT/ROLLBACK
body: <p>I have been trying to find info on the web about the differences between these statements, and it seems to me they are identical but I can't find confirmation of that or any kind of comparison between the two.</p>
  
  <p>What is the difference between doing this:</p>
  
  <pre><code>BEGIN
      -- Some update, insert, set statements
  END
  </code></pre>
  
  <p>and doing this</p>
  
  <pre><code>BEGIN TRANS
      -- Some update, insert, set statements
  COMMIT TRANS
  </code></pre>
  
  <p>?</p>
  
  <p>Note that there is only the need to rollback in the case of some exception or timeout or other general failure, there would not be a conditional reason to rollback. </p>