title: How can I fill a column with random numbers in SQL? I get the same value in every row
body: <pre><code>UPDATE CattleProds
  SET SheepTherapy=(ROUND((RAND()* 10000),0))
  WHERE SheepTherapy IS NULL
  </code></pre>
  
  <p>If I then do a SELECT I see that my random number is <a href="http://xkcd.com/221/">identical in every row</a>. Any ideas how to generate unique random numbers?</p>