title: SQL UPDATE table row range with specific range of numbers
body: <p>I am trying to use this script:</p>
  
  <pre><code>UPDATE tablename
  SET tablecolumn = abs(checksum(NewId()) % 100 + 1)
  WHERE ID between 162 and 166
  </code></pre>
  
  <p>What I am trying to do is update row 162 to 166 with 1-5 like</p>
  
  <pre><code>162 1
  163 2
  164 3
  165 4
  166 5 
  </code></pre>