Printing employee information from a table

Problem

Given a table of information about employees, write a cursor to loop through the table and print the employee ID and name for each employee.
Example input:
Employee table:
ID | Name
1 | John
2 | Jane
3 | Joe
Example output:
1 | John
2 | Jane
3 | Joe

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

/*

Solution:

DECLARE @ID INT
DECLARE @Name VARCHAR(50)

DECLARE Cursor1 CURSOR FOR
SELECT ID, Name FROM Employee

OPEN Cursor1

FETCH NEXT FROM Cursor1 INTO @ID, @Name

WHILE @@FETCH_STATUS = 0
BEGIN
	PRINT @ID + ' | ' + @Name
	FETCH NEXT FROM Cursor1 INTO @ID, @Name
END

CLOSE Cursor1
DEALLOCATE Cursor1

*/

/*

Explanation:

This solution is optimal because it uses a cursor to loop through the table and print the employee ID and name for each employee.

*/