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

1 vote353 views2 answers
Grab part of a string sql
SQL
0 vote307 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote312 views1 answer
Sql server select ignore dupplicates
SQL
1 vote329 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote297 views1 answer
How to install Firebird
SQL
0 vote316 views2 answers
Drop check constraint in ms sql
SQL
12 votes357 views5 answers
Rename table in mysql
SQL
12 votes342 views4 answers
Psql command not found
SQL
21 votes341 views1 answer
SQL cheat sheet pdf
SQL
1 vote308 views1 answer
Oracle first row
SQL