将列名的输入传递给变量并使用游标更新输入的列值

CREATE PROCEDURE update_column_value
    @column_name NVARCHAR(50),
    @new_value NVARCHAR(50)
AS
BEGIN
    DECLARE @sql NVARCHAR(MAX);
    DECLARE @cursor CURSOR;

    SET @sql = 'UPDATE your_table SET ' + @column_name + ' = @new_value';

    SET @cursor = CURSOR FOR
        SELECT column_name
        FROM information_schema.columns
        WHERE table_name = 'your_table';

    OPEN @cursor;
    FETCH NEXT FROM @cursor INTO @column_name;

    WHILE @@FETCH_STATUS = 0
    BEGIN
        EXEC sp_executesql @sql, N'@new_value NVARCHAR(50)', @new_value;

        FETCH NEXT FROM @cursor INTO @column_name;
    END;

    CLOSE @cursor;
    DEALLOCATE @cursor;
END;

EXEC update_column_value 'column_name', 'new_value';