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 votes180 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote189 views1 answer
Mysql get last 2 month data
SQL
1 vote197 views1 answer
Name of today sql
SQL
0 vote177 views2 answers
Getting customers with no orders sql
SQL
8 votes191 views4 answers
How to calculate the age from date of birth in python
SQL
5 votes183 views1 answer
Mysql count newlines in field
SQL
3 votes187 views1 answer
Postgresql today - 1 year
SQL
0 vote180 views1 answer
Insert into select with group by
SQL
0 vote173 views1 answer
Mysql date time string format for marshmellow field schema
SQL
23 votes178 views6 answers
How to create table in sql
SQL