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 vote259 views1 answer
Transaction and commit trong sql server
SQL
2 votes227 views2 answers
Install sqlalchemy
SQL
0 vote241 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote241 views1 answer
How to to get time in sql
SQL
0 vote222 views1 answer
How to access to mysql without root
SQL
0 vote257 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote261 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote225 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote238 views1 answer
Inserted row count tsql
SQL
3 votes241 views1 answer
Dbms_scheduler drop_job
SQL