CREATE TRIGGER nie_obnizaj_pensji
ON pracownik
FOR UPDATE
AS
BEGIN

DECLARE kursor_deleted CURSOR
FOR
SELECT pensja FROM deleted;

DECLARE kursor_inserted CURSOR
FOR
SELECT nr_pracownika,pensja FROM inserted;

OPEN kursor_deleted
OPEN kursor_inserted

DECLARE @pensja_inserted decimal(8,2)
DECLARE @pensja_deleted decimal(8,2)
DECLARE @nr_pracownika char(4);

FETCH NEXT FROM kursor_deleted INTO @pensja_deleted
FETCH NEXT FROM kursor_inserted INTO @nr_pracownika, @pensja_inserted

WHILE @@FETCH_STATUS = 0
BEGIN
  SET NOCOUNT ON
  IF @pensja_inserted < @pensja_deleted
	BEGIN
	  print 'Blad nie mozna obnizyc pensji pracownikowi'
	  UPDATE pracownik SET pensja=@pensja_deleted
	  WHERE nr_pracownika = @nr_pracownika;
	END
  FETCH NEXT FROM kursor_deleted INTO @pensja_deleted
  FETCH NEXT FROM kursor_inserted INTO @nr_pracownika, @pensja_inserted
END

CLOSE kursor_deleted
CLOSE kursor_inserted
DEALLOCATE kursor_deleted
DEALLOCATE kursor_inserted
END