title: Bulk copy of data from one column to another in SQL Server
body: <p>I want to copy the value of one column to another column in SQL Server. This operation needs to be carried out across the <strong>whole DB</strong> which has <strong>200M</strong> rows. My query syntax is: </p>
  
  <pre><code>UPDATE [Net].[dbo].[LINK]
  SET  [LINK_ERRORS] = [OLD_LINK_ERRORS]
  </code></pre>
  
  <p>However, very soon I exhaust the transaction log and the query aborts. What's the best way to initiate this in batches?</p>
  
  <p>Thanks,</p>