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

22 votes163 views4 answers
Show list of users in mysql
SQL
8 votes209 views4 answers
Convert date to dd/mm/yyyy sql
SQL
3 votes202 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote160 views1 answer
Tsql delete all rows
SQL
0 vote186 views1 answer
How convert into in in sql query
SQL
0 vote195 views2 answers
What is rownum in oracle
SQL
0 vote200 views3 answers
Mysql CAST(amount as float)
SQL
0 vote168 views1 answer
Mysql streaming example
SQL
-1 vote113 views2 answers
Datetime sql server week
SQL
5 votes190 views1 answer
Oracle generate list of dates in between a date range
SQL