Sql server for-each或while行

DECLARE @id INT
DECLARE @name VARCHAR(50)

DECLARE cursor_name CURSOR FOR
SELECT id, name FROM your_table

OPEN cursor_name

FETCH NEXT FROM cursor_name INTO @id, @name

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在这里处理每一行的数据
    -- 可以使用 @id 和 @name 变量来访问每一行的值

    FETCH NEXT FROM cursor_name INTO @id, @name
END

CLOSE cursor_name
DEALLOCATE cursor_name

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

SET @rowCount = (SELECT COUNT(*) FROM your_table)

SET @id = 1

WHILE @id <= @rowCount
BEGIN
    SELECT @name = name FROM your_table WHERE id = @id

    -- 在这里处理每一行的数据
    -- 可以使用 @id 和 @name 变量来访问每一行的值

    SET @id = @id + 1
END