title: Multiple Begin Transactions
body: <p>I came across this today and accident and was wondering a few things. The basic code setup is</p>
  
  <pre><code>Begin Transaction 
  Update Table
  set column to value
  
  Begin transaction
  Update Table
  set column to value
  </code></pre>
  
  <p>I have played with it a little and found you can not do a commit after a doing a rollback, but you can do a commit before a rollback, however the rollback negates the commit. I guess my question is, is there any purpose/use for this? I see not other then making my DBA slap me for bad code lol</p>