用for循环和游标，打印出10部门的所有雇员的姓名和工资(使用循环游标)

假设需要打印的表名为employee，其中包含字段为name、salary和department。

可以按照以下步骤进行操作：

1. 创建一个游标，用于循环遍历每个部门。

DECLARE dept_cursor CURSOR FOR SELECT DISTINCT department FROM employee;

2. 打开游标。

OPEN dept_cursor;

3. 使用循环语句循环遍历每个部门，并在循环内创建一个子游标，用于遍历该部门的所有雇员。

DECLARE @department VARCHAR(50);
DECLARE emp_cursor CURSOR FOR
SELECT name, salary FROM employee WHERE department = @department;

FETCH NEXT FROM dept_cursor INTO @department;
WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT 'Department: ' + @department;

    OPEN emp_cursor;
    FETCH NEXT FROM emp_cursor INTO @name, @salary;
    WHILE @@FETCH_STATUS = 0
    BEGIN
        PRINT @name + ' ' + CAST(@salary AS VARCHAR(10));
        FETCH NEXT FROM emp_cursor INTO @name, @salary;
    END
    CLOSE emp_cursor;
    DEALLOCATE emp_cursor;

    FETCH NEXT FROM dept_cursor INTO @department;
END

4. 关闭游标并释放资源。

CLOSE dept_cursor;
DEALLOCATE dept_cursor;