title: Can I Select and Update at the same time more than 1 record?
body: <p>refer this 
  link: <a href="https://stackoverflow.com/questions/2296718/can-i-select-and-update-at-the-same-time">sample Q</a></p>
  
  <p>i want to Select and Update at the same time more than 1 record. using sql server.
  above link process with one record but i want more than 1. but not using any temp object. for the selecting, has condition to chk.</p>
  
  <pre class="lang-html prettyprint-override"><code>select top 100 *
  from table1
  where isUpdate = 0
  
  update table1 set isupdate = 1...... 
  </code></pre>
  
  
  
  <p><strong>is it possible or not?</strong></p>
  
  <p>thanks.</p>