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 vote189 views1 answer
Hive batch drop table
SQL
0 vote190 views2 answers
Tsql row number
SQL
8 votes201 views1 answer
Mysql limit rows
SQL
0 vote217 views1 answer
Java spring boot connect to sql server
SQL
0 vote173 views1 answer
Trim sql oracle
SQL
1 vote174 views1 answer
Mysql batch insert
SQL
0 vote225 views1 answer
Transalations from sql to Linq count and group by
SQL
2 votes188 views2 answers
Select multiple tables mysql
SQL
0 vote184 views1 answer
Vowels in sql
SQL
-1 vote235 views1 answer
Search all sql tables for a value
SQL