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 vote147 views1 answer
Mysql count words
SQL
2 votes171 views3 answers
Sql function
SQL
16 votes153 views3 answers
T-SQL Add Column
SQL
0 vote155 views1 answer
Check if database exists sql
SQL
2 votes153 views4 answers
Mysql get all tables row count
SQL
2 votes156 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote161 views1 answer
Query archive mode
SQL
0 vote153 views1 answer
Mysql return column names when table is empty
SQL
-1 vote165 views1 answer
Capitole toulouse
SQL
0 vote140 views1 answer
Oracle last user logon
SQL