About sql server stored procedure for updating serial no column

Hi,

Create a stored proc which contains the below code,

-- Get the number of rows in the looping table
DECLARE @RowCount INT
SET @RowCount = (SELECT COUNT(SN) FROM @myTable where SN > @serialNumber)

-- Declare an iterator
DECLARE @I INT
-- Initialize the iterator
SET @sn = @serialNumber + 1;
SET @I = 1;

-- Loop through the rows of a table @myTable
WHILE (@I <= @RowCount)
BEGIN

UPDATE @myTable SET SN = @sn - 1 where SN = @sn

SET @sn = @sn + 1

-- Increment the iterator
SET @I = @I + 1

END