DECLARE @intFlag INT
SET @intFlag = 1
WHILE (@intFlag <=28)
BEGIN
UPDATE 'TABLE NAME'
SET 'Column Name' = '000000' -- Note: Column Name that you want to update.
WHERE ('Column ID' = @intFlag) -- Note: Unique Column ID of TAble
SET @intFlag = @intFlag + 1
END
GO
Add a comment