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

0 vote170 views1 answer
Mysql installer no packages found
SQL
0 vote185 views1 answer
Providername system.data. mysql
SQL
6 votes173 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote175 views1 answer
Delete record by id sql
SQL
0 vote195 views1 answer
Calculer pourcentage mysql
SQL
0 vote197 views1 answer
Psql check table fields
SQL
0 vote163 views1 answer
Mysql show foreign keys column
SQL
0 vote163 views1 answer
How to access to mysql without root
SQL
1 vote181 views1 answer
Select last row from SQL Table
SQL
1 vote175 views1 answer
Sqlite create index
SQL