title: how to duplicate row in table and update the IDs of the proceeding rows in a sproc?
body: <p>I have the following table:
  <img src="https://i.stack.imgur.com/Rla8q.png" alt="enter image description here"></p>
  
  <p>Im working on a procedure which takes in a row ID eg.5 and duplicates it into a new row with the ID of 6. by doing this I have to update the proceeding ids of item 6 to 7, 7 to 8, 8 to 9, 9 to 10 and 10 to 11.</p>
  
  <p>what is the best way of doing this? </p>
  
  <p>I am totally clueless in SQL manipulation so any help would be greatly appreciated.</p>