title: How to update table in SQL server with out changing timestamp field value
body: <p>I want to update a table and prevent it's <code>timestamp</code> column to be updated automatically, how can I overcome?</p>
  
  <p>for example I have this table</p>
  
  <pre><code>Table1 (id int,Name varchar(50),version timestamp)
  </code></pre>
  
  <p>consider I want to update Name but I don't want the version column get updated Automatically,</p>
  
  <p>I tried</p>
  
  <pre><code>Update Table1 set Name = 'NewName' , [version] = [version] 
  </code></pre>
  
  <p>but it doesn't work and says</p>
  
  <p><code>Msg 272, Level 16, State 1, Line 1
  Cannot update a timestamp column.</code></p>