title: Set iterative values in rows of a table
body: <p>I have the following table</p>
  
  <pre><code>id name address empid
  
  1  AA   aa      0
  2  BB   bb      0
  3  CC   cc      0
  </code></pre>
  
  <p>I need to write a query to set empid starting from 1. How to write it please. Do i have to use a stored procedure to that or can do it with a normal query?</p>
  
  <p>Thank You.</p>