title: How can I rollback an UPDATE query in SQL server 2014?
body: <p>I know this question was asked many times for previous versions of SQL Server but I’m wondering if this was made easier in SQL Server 2014.</p>
  
  <p>I’m familiar with the techniques for other versions that are shown here</p>
  
  <p><a href="https://stackoverflow.com/questions/721471/how-can-i-rollback-an-update-query-in-sql-server-2005/721511">How can I rollback an UPDATE query in SQL server 2005?</a></p>
  
  <p><a href="https://stackoverflow.com/questions/2984966/undo-table-updates-in-sql-server-2008">Undo table updates in SQL Server 2008</a></p>
  
  <p>So question is: Is there anything that will allow to rollback and UPDATE query in SQL Server 2014 that was not available in previous versions?  </p>
  
  <p>I’m talking committed command – I know you can rollback if query is inside transaction. </p>
  
  <p>We have full, differential and transaction log backups in place but we’d really like to avoid recovery scenarios with restoring backups into secondary database and such… </p>