T sql cursor tr

BEGIN
  DECLARE cur_employee CURSOR FOR
      SELECT Surname
      FROM Employees;
  DECLARE name CHAR(40);
  OPEN cur_employee;
  lp: LOOP
    FETCH NEXT cur_employee INTO name;
    IF SQLCODE <> 0 THEN LEAVE lp END IF;
    ...
  END LOOP;
  CLOSE cur_employee;
END

Source: dcx.sap.com

Similar codes

1 vote312 views1 answer
Postgres first_value in gropby
SQL
4 votes329 views4 answers
What is primary key
SQL
0 vote326 views1 answer
Postgres clear table
SQL
5 votes320 views1 answer
Oracle list functions
SQL
3 votes297 views1 answer
Oracle user quota unlimited
SQL
-1 vote336 views3 answers
My sql alter table
SQL
-1 vote305 views3 answers
Check table exist postgresql
SQL
0 vote314 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote317 views1 answer
Alasql delete column
SQL
1 vote332 views2 answers
Select into temp table
SQL