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 vote147 views1 answer
Postgresql linux password
SQL
-3 votes127 views1 answer
Remove spaces sql 2008
SQL
0 vote134 views1 answer
Mariadb search columns
SQL
0 vote134 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote134 views1 answer
Oracle create job if not exists
SQL
0 vote133 views1 answer
Opensuse status MySQL
SQL
0 vote137 views2 answers
Create new table plsql
SQL
1 vote138 views1 answer
Postgresql substring last
SQL
6 votes139 views2 answers
Stored procedure to delete data from table in mysql
SQL
1 vote139 views3 answers
Sql select only time from datetime
SQL