title: How to bulk-update a SQL table with random data in one step?
body: <p>I have a large table in which, for testing purposes, I want to update a column to a different random value on each row.</p>
  
  <p>If I say:</p>
  
  <pre><code>update MyTable
  set MyCol = Rand()*100
  </code></pre>
  
  <p>then the value is, indeed, random - but it's the same random number applied to every row.</p>
  
  <p>I could use a cursor to iterate and update each row, one by one, and that's obviously what I'll fall back on if necessary.  But is there some SQL syntax that will update each row with a different random value, in one succinct statement?</p>