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 vote105 views2 answers
T SQl Checking Your Username
SQL
0 vote120 views2 answers
Collation in sql
SQL
0 vote96 views1 answer
Increment id in mysql
SQL
1 vote100 views1 answer
List index mysql cli
SQL
0 vote108 views1 answer
Mysql root permission denied lost
SQL
0 vote96 views2 answers
Functions with parameters SQL
SQL
0 vote105 views1 answer
Sqlserver now
SQL
-2 votes110 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote105 views1 answer
Assign value to var in SQL
SQL
16 votes102 views3 answers
T-SQL Add Column
SQL