如何使用循环更新sql中的行？

DECLARE @id INT
DECLARE @name VARCHAR(50)
DECLARE @age INT

DECLARE myCursor CURSOR FOR
SELECT id, name, age
FROM your_table
WHERE condition -- 这里是你的条件

OPEN myCursor
FETCH NEXT FROM myCursor INTO @id, @name, @age

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在这里执行你的更新操作
    UPDATE your_table
    SET column1 = value1, column2 = value2
    WHERE id = @id

    FETCH NEXT FROM myCursor INTO @id, @name, @age
END

CLOSE myCursor
DEALLOCATE myCursor