title: rearrange the identity column value in sql server
body: <hr>
  
  <p>Please help me! I have a table will a identity field the value are,
  for example, 1, 2, 4, 6, 8, 10, 11 .... etc.</p>
  
  <p>I want to make it in a sequence, that is, 1,2,3,4,5,6,7... without using drop</p>
  
  <p>Thanks</p>