SQL Server：打印输出不会立即出现

SQL Server是一款广泛应用于企业级数据库管理系统的软件。但是，有时候在使用SQL Server时，我们可能会遇到一个常见的问题，即打印输出不会立即出现。这意味着当我们在SQL Server中执行一条打印语句时，它的输出结果不会立即显示在终端窗口中。相反，它会在整个查询或批处理完成后才显示出来。

sql
CREATE TABLE employees (
    emp_id INT,
    emp_name VARCHAR(50),
    emp_salary DECIMAL(10, 2)
);
INSERT INTO employees (emp_id, emp_name, emp_salary)
VALUES (1, 'John Doe', 5000.00),
       (2, 'Jane Smith', 6000.00),
       (3, 'Bob Johnson', 4500.00);

sql
DECLARE @emp_id INT;
DECLARE @emp_name VARCHAR(50);
DECLARE @emp_salary DECIMAL(10, 2);
DECLARE employee_cursor CURSOR FOR
    SELECT emp_id, emp_name, emp_salary
    FROM employees;
OPEN employee_cursor;
FETCH NEXT FROM employee_cursor INTO @emp_id, @emp_name, @emp_salary;
WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT 'Employee ID: ' + CAST(@emp_id AS VARCHAR(10));
    PRINT 'Employee Name: ' + @emp_name;
    PRINT 'Employee Salary: ' + CAST(@emp_salary AS VARCHAR(10));
    FETCH NEXT FROM employee_cursor INTO @emp_id, @emp_name, @emp_salary;
END;
CLOSE employee_cursor;
DEALLOCATE employee_cursor;

sql
DECLARE @emp_id INT;
DECLARE @emp_name VARCHAR(50);
DECLARE @emp_salary DECIMAL(10, 2);
DECLARE employee_cursor CURSOR FOR
    SELECT emp_id, emp_name, emp_salary
    FROM employees;
OPEN employee_cursor;
FETCH NEXT FROM employee_cursor INTO @emp_id, @emp_name, @emp_salary;
WHILE @@FETCH_STATUS = 0
BEGIN
    RAISERROR('Employee ID: %d', 0, 1, @emp_id);
    RAISERROR('Employee Name: %s', 0, 1, @emp_name);
    RAISERROR('Employee Salary: %.2f', 0, 1, @emp_salary);
    FETCH NEXT FROM employee_cursor INTO @emp_id, @emp_name, @emp_salary;
END;
CLOSE employee_cursor;
DEALLOCATE employee_cursor;