Cursor: komplettes Beispiel

• DECLARE crsKundenHeuer CURSOR

• • FAST_FORWARD FOR
  • • SELECT DISTINCT KundenNr
    • • FROM datKunden AS k INNER JOIN
      • • datAufträge AS a ON
        • k.Nr = a.KundenNr
        • WHERE year (Datum) = year(getdate());

• OPEN crsKundenHeuer;

• DECLARE @KNr int;

• FETCH NEXT crsKundenHeuer INTO @KNr;

• WHILE @@fetch_status = 0

• • BEGIN
  • --hier irgendeine Bearbeitung
  • FETCH NEXT crsKundenHeuer INTO @Knr;
  • END
  • CLOSE crsKundenHeuer;
  • DEALLOCATE crsKundenHeuer;