sposob pre mysql
DECLARE _ID INT;
DECLARE XCUR CURSOR FOR SELECT ID FROM DOKLADY;
OPEN XCUR;
BEGIN
DECLARE EXIT HANDLER FOR NOT FOUND BEGIN END;
LOOP
FETCH XCUR INTO _ID;
// inserty ako v pripade MS SQL
END LOOP;
END;
CLOSE XCUR;
poradna.net
Neregistrovaný Přihlásit Registrovat