title: sql cancelling query without reverting everything back
body: <p>I have been running many 'insert into' statement in one go with SQL server and sometimes while loop.</p>
  
  <pre><code>While
  begin
    insert into
  
  end
  </code></pre>
  
  <p>Usually it takes very long to finish. Sometimes I have to cancel the query before it finish. When I do, it reverts everything it has inserted. Is there a way that I only cancel the 'insert into' it is running now and keep what has been inserted in the previous loop?</p>
  
  <p>Many thanks.</p>