sql游标实例怎么用-SQL

DECLARE cursor_name CURSOR FOR
SELECT * FROM table_name;

OPEN cursor_name;

FETCH NEXT FROM cursor_name INTO variable1, variable2, ...;

-- cursor_name
print variable1
print variable2

CLOSE cursor_name;

DECLARE employee_cursor CURSOR FOR
SELECT employee_id, first_name, last_name
FROM employees;

OPEN employee_cursor;

FETCH NEXT FROM employee_cursor INTO e_id, f_name, l_name;

-- 打印当前行值
PRINT e_id, f_name, l_name;

-- 移动到下一行
FETCH NEXT FROM employee_cursor INTO e_id, f_name, l_name;

-- 打印当前行值
PRINT e_id, f_name, l_name;

CLOSE employee_cursor;