title: Rollback the inner transaction of nested transaction
body: <p>suppose I have following sql statement in sql server 2008:</p>
  
  <pre><code>BEGIN TRANSACTION    
  SqlStatement1    
  EXEC sp1    
  SqlStatement3
  COMMIT TRANSACTION
  </code></pre>
  
  <p>The code of sp1</p>
  
  <pre><code>BEGIN TRANSACTION
  SqlStatement2
  ROLLBACK TRANSACTION
  </code></pre>
  
  <p>My question is: Is <code>SqlStatement3</code> actually executed?</p>