title: SQL Server RowNumbering
body: <pre><code>SrNo   TextCol
  --------------
  NULL   ABC
  NULL   ABC
  NULL   ASC
  NULL   qwe
  </code></pre>
  
  <p>I want to update the <code>SrNo</code> column with numbers 1,2,3,4 without changing sequence of other columns. </p>