Untitled

-- create
CREATE TABLE EMPLOYEE (
  empId int,
  name varchar(15),
  dept varchar(10),
  salary int
);

-- insert
INSERT INTO EMPLOYEE(empId,name,dept, salary) VALUES (1, 'Clark', 'Sales', 3000);
INSERT INTO EMPLOYEE(empId,name,dept, salary) VALUES (2, 'Dave', 'Accounting', 5000);
INSERT INTO EMPLOYEE(empId,name,dept, salary) VALUES (3, 'Ava', 'Sales', 5050);

-- fetch 
SELECT * FROM EMPLOYEE;

DECLARE employee_cursor CURSOR FOR
SELECT empId, name, dept, salary FROM EMPLOYEE;

DECLARE @empId INT, @name VARCHAR(15), @dept VARCHAR(10), @salary INT;

OPEN employee_cursor;

FETCH NEXT FROM employee_cursor INTO @empId, @name, @dept, @salary;

WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT 'EmpId: ' + CAST(@empId AS VARCHAR) + ', Name: ' + @name + ', Dept: ' + @dept + ', Salary: ' + CAST(@salary AS VARCHAR);
    
    FETCH NEXT FROM employee_cursor INTO @empId, @name, @dept, @salary;
END

CLOSE employee_cursor;
DEALLOCATE employee_cursor;