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

4 votes192 views1 answer
List tables sqlite
SQL
11 votes164 views1 answer
Mysql order by two columns priority
SQL
0 vote197 views1 answer
Unique element in sql
SQL
0 vote149 views2 answers
Postgresql display subquery as json
SQL
0 vote175 views1 answer
How to connect to mysql in ef 6
SQL
1 vote167 views1 answer
Oracle explain plan
SQL
0 vote385 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote184 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote176 views1 answer
Yesql
SQL
36 votes178 views6 answers
Rename table sql
SQL