title: Safely delete rows in sqlserver so you can rollback a commit
body: <p>I asked this question yesterday <a href="https://stackoverflow.com/questions/17552807/trying-to-delete-from-join-and-i-know-i-have-funky-spacing-and-i-know-i-have-dup">Funky Delete Issue</a></p>
  
  <p>Now I'd like to now how to delete safely.</p>
  
  <p>So how do I use commits and transactions and that syntactical sugar to cover my @$$ because yesterday I dumbly deleted 51,000 rows. I had a backup but I still thought HOLY ^%$# that was too easy.</p>
  
  <p>So how do I safely:</p>
  
  <pre><code>    DELETE FROM bBoxHeader
      WHERE bBoxHeader.bHeaderId &lt;&gt; '1099' 
      -- Ooops meant that to be equal. How do I roll back?
  </code></pre>
  
  <p>How do I wrap that so I don't blow away 51000 rows</p>