title: Can someone please clarify be on the below explanation
body: <p>I have a Employee table with 5 records, And i am running the below script. the result of the script is returning a record with EmpID 2. at the same time record is getting deleted.
  Is this is the right way?</p>
  
  <pre><code>begin transaction A
      select * from Employee where EmpID=2
      begin transaction B
          delete from Employee where EmpID=2
      commit transaction B
  commit transaction A
  </code></pre>