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 vote172 views1 answer
Mysql server does not start mac
SQL
1 vote181 views1 answer
Mysql get last insert id
SQL
11 votes177 views3 answers
Sqlite3 create table from another table
SQL
0 vote196 views1 answer
View psql output in horizontal scrolling
SQL
0 vote172 views1 answer
Psql select * from table
SQL
0 vote189 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
2 votes169 views2 answers
Oracle create table if not exists
SQL
5 votes204 views1 answer
Oracle asynchronous query
SQL
1 vote170 views1 answer
Set statistics on in ssms
SQL
7 votes199 views5 answers
Max 3 salary in sql
SQL