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

3 votes216 views1 answer
Oracle function return
SQL
0 vote212 views1 answer
Query archive mode
SQL
1 vote327 views2 answers
Postgres select from last 3 months
SQL
0 vote196 views2 answers
Sql last updated
SQL
3 votes251 views1 answer
Sql several or
SQL
1 vote294 views1 answer
Column with prefix in sql
SQL
0 vote212 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
4 votes213 views3 answers
Drop Table Oracle
SQL
0 vote194 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote236 views1 answer
Como hacer un select entre fechas mysql
SQL