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

4 votes258 views1 answer
SQL order random
SQL
0 vote257 views1 answer
Mysql with
SQL
0 vote283 views1 answer
How to read the potentail error messages in ssis package
SQL
56 votes516 views5 answers
Psql create user
SQL
3 votes259 views1 answer
Oracle nextval
SQL
0 vote272 views1 answer
Count characters of string mysql
SQL
13 votes268 views2 answers
Oracle inner join
SQL
0 vote288 views1 answer
Get date from timestamp in mysql
SQL
1 vote279 views1 answer
Postgres convert date to string
SQL
0 vote297 views1 answer
Psql get table data types
SQL