title: SQL simplist way to update an INT identity column
body: <p>I have a column called fixedID, and it's current Value = <code>2</code>, I want to update this value to be <code>42</code>.  What is the best way to do this.  I would like to do this modification as simply as possible.  However, if I could do this while doing an select insert that would be fantastic also.</p>
  
  <pre><code>update tblFixedId
  set FixedId = (FixedId + 400)
  </code></pre>
  
  <p>possible to change the value here?</p>
  
  <pre><code>Select * INTO mynewTable from myOldertable
  </code></pre>