Why not just update all after the id that was removed? Like that you don’t need a while, and performance will go up 300%.
update questions set no = no - 1 where no > @yourRemovedID
solved Loop is not working C#.net
Why not just update all after the id that was removed? Like that you don’t need a while, and performance will go up 300%.
update questions set no = no - 1 where no > @yourRemovedID
solved Loop is not working C#.net