update semi-incremental column [ 881 views ]
To add incremental numbers into a column (not an auto increment column) is easy with a stored procedure but we can use a simple update also.
DECLARE @counter int SET @counter = 0 UPDATE [TABLE_NAME] SET @counter = [COLUMN_NAME] = @counter + 1
done.