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 vote108 views1 answer
Querry mysql by 2 columns
SQL
0 vote127 views1 answer
Sql_inner_join
SQL
6 votes91 views3 answers
Mysql server is not starting xampp
SQL
0 vote57 views1 answer
How to set field to null in sql
SQL
0 vote97 views1 answer
Remove from table where
SQL
12 votes105 views1 answer
Docker mysql random root password
SQL
8 votes92 views1 answer
Sql remove characters from string right
SQL
4 votes101 views2 answers
Select first and last row mysql
SQL
59 votes271 views6 answers
Alter table sql
SQL
6 votes102 views1 answer
SQL insert all columns
SQL