title: SQL Server : UPDATE MyTable SET col1 = value, col2 = col1
body: <p>I have a table col1 float, col2 float with the following data:</p>
  <blockquote>
  <p>1,2</p>
  <p>3,4</p>
  </blockquote>
  <p>After the query:</p>
  <pre><code>UPDATE MyTable SET col1 = 100, col2 = col1
  </code></pre>
  <p>is executed, the rows are:</p>
  <blockquote>
  <p>100,1</p>
  <p>100,3</p>
  </blockquote>
  <p>Obviously, the old, not updated value of col1 is used, when col2 is being updated. Is it possible to update the col2 with the new value, referring col1 or I have to write the value (100) twice? I want to use auto-generated queries and it's easier to keep formulas.</p>
  <p>Regards,</p>