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 vote346 views1 answer
Sql count value greater than
SQL
0 vote340 views1 answer
Postgresql print sessions using the database
SQL
13 votes306 views6 answers
Restart postgresql
SQL
2 votes305 views1 answer
Sql ends with string
SQL
0 vote341 views1 answer
Get total and distict row diff in sql
SQL
0 vote318 views1 answer
Sql put two columns into one
SQL
4 votes334 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
2 votes308 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote317 views1 answer
How to get specific salary in sql
SQL
1 vote283 views1 answer
Sql update table remove spaces
SQL