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 vote370 views1 answer
How to fetch data from database in sql
SQL
0 vote331 views1 answer
Copied text from internet not inserting in mysql
SQL
5 votes331 views1 answer
Mysql change primary key
SQL
2 votes353 views1 answer
Can you use a where clause for a child query
SQL
0 vote343 views1 answer
Postgres week number
SQL
0 vote350 views1 answer
Hour differeence in mysql
SQL
0 vote311 views1 answer
Declaring variables in pl sql
SQL
0 vote349 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote360 views1 answer
Nvl2 syntax
SQL
24 votes315 views5 answers
Sql reset auto increment
SQL