Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. create trigger AdminInITUpdateMitarbeier before update on Mitarbeiter
  2. when NEW.Bereich != 'IT' and exists (
  3. select * from Administrator
  4. where MitarbeiterBenutzerEmail = NEW.BenutzerEmail
  5. )
  6. begin
  7. select RAISE(ABORT,"Administrator muss im Bereich IT arbeiten")
  8. end;
  9. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement