T SQL循环通过表和更新字段

DECLARE @counter INT
SET @counter = 1

WHILE @counter <= (SELECT COUNT(*) FROM YourTable)
BEGIN
    UPDATE YourTable
    SET YourField = 'Updated'
    WHERE ID = @counter

    SET @counter = @counter + 1
END

DECLARE @id INT
DECLARE @value VARCHAR(50)

DECLARE cursor_name CURSOR FOR
SELECT ID, YourField
FROM YourTable

OPEN cursor_name

FETCH NEXT FROM cursor_name INTO @id, @value

WHILE @@FETCH_STATUS = 0
BEGIN
    UPDATE YourTable
    SET YourField = 'Updated'
    WHERE ID = @id

    FETCH NEXT FROM cursor_name INTO @id, @value
END

CLOSE cursor_name
DEALLOCATE cursor_name