title: SQL Server: how to update a column for a rows range?
body: <p>Working environment is SQL Server 2000. I have a table with no indexes, no PK... Total number of rows is 600,000.</p>
  
  <p>How can I update a column from row 0 -> 100,000 with a value then from 100,001 -> 200,000 with another, and so on?</p>
  
  <p>Thank you.</p>