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 vote112 views4 answers
User defined function sql
SQL
-2 votes121 views2 answers
Union all in sql
SQL
19 votes111 views5 answers
Change column name mysql command line
SQL
13 votes114 views2 answers
Sqlite rename table
SQL
2 votes63 views1 answer
Sql select min value from multiple columns
SQL
10 votes58 views1 answer
Oracle view dependencies
SQL
17 votes236 views4 answers
Show all tables in oracle
SQL
0 vote126 views1 answer
Sql server rtrim everything after character
SQL
6 votes106 views2 answers
Mysql execute file
SQL
1 vote112 views1 answer
Oracle stop job
SQL