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 vote159 views1 answer
MYSQL stored procedure select from
SQL
0 vote148 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
3 votes145 views1 answer
Oracle apex warning message
SQL
0 vote143 views1 answer
T-SQL Retry (deadlock)
SQL
2 votes131 views1 answer
Sqlplus clear screen
SQL
0 vote164 views1 answer
Mysql value ends with
SQL
0 vote146 views1 answer
Mysql count with two joins
SQL
0 vote150 views1 answer
Select even number id data from table
SQL
0 vote132 views1 answer
Get sum sqlite android
SQL
0 vote145 views1 answer
What is SQL data store?
SQL