title: Return the total rows affected by SQL Transaction
body: <p>I have the following code in sql:</p>
  
  <pre><code>SET XACT_ABORT ON
  Begin Transaction
  INSERT INTO TABLE_A VALUES(/*Some Values*/)
  INSERT INTO TABLE_B VALUES(/*Some Values*/)
  INSERT INTO TABLE_C VALUES(/*Some Values*/)
  
  Update Table Set Values A = A WHERE id = @id /* Some thing like that*/
  Commit Transaction
  </code></pre>
  
  <p>So, i just wanted to know the total number of rows affected by in my Transaction Block of Insert and Updte statement</p>