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 vote262 views1 answer
Select dba users oracle
SQL
0 vote265 views1 answer
Psql attribute cannot login
SQL
0 vote302 views1 answer
Gcloud sql list databases
SQL
0 vote291 views1 answer
Change date format in oracle query
SQL
9 votes254 views1 answer
Identity insert on sql server
SQL
0 vote250 views1 answer
Oracle list index on table
SQL
5 votes262 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
11 votes261 views2 answers
Set default column value sql
SQL
0 vote258 views4 answers
Database stuck at restoring state
SQL
0 vote271 views1 answer
Custom row number
SQL