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

4 votes159 views1 answer
Find tables with column name in sql
SQL
0 vote149 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
4 votes162 views5 answers
Primary key
SQL
0 vote162 views1 answer
Write SQL in ruby on rails
SQL
0 vote167 views1 answer
Query only first letter string
SQL
18 votes156 views4 answers
Mysql current date between two dates
SQL
9 votes171 views1 answer
Identity insert on sql server
SQL
0 vote180 views2 answers
Plpgsql
SQL
0 vote153 views1 answer
Sql create text column limited values
SQL
1 vote168 views1 answer
Change table to innodb mysql
SQL