title: How to reorder auto increment column values, after deleting any row other than last row?
body: <p>I want to know is there any <strong>SQL query for asp.net,c#</strong> that can just re arrange auto increment coloumn values..</p>
  
  <p>eg.
  deleting 2 in the table:</p>
  
  <p>sno</p>
  
  <p>1</p>
  
  <p>2 </p>
  
  <p>3</p>
  
  <p>4</p>
  
  <p>does: </p>
  
  <p>sno</p>
  
  <p>1</p>
  
  <p>3</p>
  
  <p>4</p>
  
  <p>but i want re-arrangement:</p>
  
  <p>sno</p>
  
  <p>1</p>
  
  <p>2</p>
  
  <p>3</p>
  
  <p>Note:</p>
  
  <ol>
  <li>Don't want to to the numbering manually</li>
  <li>query to create table is like this:</li>
  </ol>
  
  <p><code>CREATE TABLE uid (sno int IDENTITY(1,1) PRIMARY KEY, qpname nvarchar(500), mob int, tm int)</code>    </p>