如何在SQL server中更新列直到值发生更改。

CREATE PROCEDURE UpdateColumnUntilChanged
    @TableName NVARCHAR(128),
    @ColumnName NVARCHAR(128),
    @NewValue NVARCHAR(MAX)
AS
BEGIN
    SET NOCOUNT ON;
    
    DECLARE @CurrentValue NVARCHAR(MAX);
    
    -- 获取当前列的值
    SELECT @CurrentValue = @ColumnName
    FROM @TableName;
    
    WHILE @CurrentValue = @ColumnName
    BEGIN
        -- 更新列的值为新值
        UPDATE @TableName
        SET @ColumnName = @NewValue;
        
        -- 获取更新后的值
        SELECT @CurrentValue = @ColumnName
        FROM @TableName;
        
        -- 检查更新后的值是否与变量的值相同
        IF @CurrentValue = @ColumnName
            BREAK; -- 退出循环
    END;
END;