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

10 votes382 views5 answers
Create table mysql query
SQL
0 vote346 views1 answer
Postgresql array to rows
SQL
0 vote354 views1 answer
Sql composite key
SQL
0 vote343 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote407 views1 answer
Wordpress make wp user in db
SQL
-2 votes344 views1 answer
Use of where in left join in mysql
SQL
0 vote400 views1 answer
New rails app with mysql
SQL
0 vote339 views1 answer
Mysql find db contarint
SQL
1 vote382 views1 answer
Sqlite update from another table
SQL
-1 vote373 views3 answers
Error: mysql shutdown unexpectedly.
SQL