title: Updating 10 rows based on primary key
body: <p>I have a table which contains 1000000 records and I want to update 10 records from that based on primary key and my [date-time] is the primary key column in my table where the update condition is like this:</p>
  
  <pre><code>update table 
     set speed='0.000000' 
   where [date-time]&gt;'2014-08-06 21:33:01.000'
     and [date-time]&lt;'2014-08-06 21:38:32.000'
  </code></pre>