title: How to renumber the field value in SQL using SQL script
body: <p>I have a table, with one Datatype [int] column [<strong>LNITMSEQ</strong>]. The numbers are all unique.
  For example,</p>
  <p>first row value = 16384,</p>
  <p>second row value = 32768 = 16384*2</p>
  <p><strong>Before Delete a record,</strong></p>
  <p><a href="https://i.stack.imgur.com/fbanC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fbanC.jpg" alt="Original" /></a></p>
  <p><strong>After Delete Record</strong></p>
  <p><a href="https://i.stack.imgur.com/BGfX0.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BGfX0.jpg" alt="Renumber" /></a></p>
  <p>May I now how to renumber it using SQL Script? I wish to use Store Procedure to call it</p>