sql的for循环语法结构解析_产品动态_资讯中心

发布时间:2026-04-27 18:30:56

阅读量:3

在 SQL 中，没有名为 “FOR” 的循环语法结构

WHILE 循环：这是一种常见的循环结构，用于在满足特定条件时重复执行一组 SQL 语句。以下是一个简单的 WHILE 循环示例：

DECLARE @counter INT = 0;

WHILE @counter < 5
BEGIN
    PRINT 'Counter value: ' + CAST(@counter AS VARCHAR);
    SET @counter = @counter + 1;
END;

CURSOR：游标用于遍历查询结果集。通过使用游标，可以在每次迭代时处理一行数据。以下是一个简单的游标示例：

DECLARE @employee_id INT, @employee_name NVARCHAR(50);

DECLARE employee_cursor CURSOR FOR
SELECT employee_id, employee_name FROM employees;

OPEN employee_cursor;

FETCH NEXT FROM employee_cursor INTO @employee_id, @employee_name;

WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT 'Employee ID: ' + CAST(@employee_id AS VARCHAR) + ', Employee Name: ' + @employee_name;
    FETCH NEXT FROM employee_cursor INTO @employee_id, @employee_name;
END;

CLOSE employee_cursor;
DEALLOCATE employee_cursor;