title: How to rollback SQL update command?
body: <p>In SQL server 2008 R2. Is it possible to do a rollback on a single update command?</p>
  
  <p>I know there are other questiones like this on SO but i havent seen one specific for 2008 R2 and hence I may get the same answer, if that is the case then we can close this thread.</p>
  
  <p>I did the a simple update without any transactions commands:</p>
  
  <pre><code>UPDATE myTable SET col1=somevalue WHERE....
  </code></pre>