Advertisement
Guest User

Untitled

a guest
Mar 4th, 2013
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. CREATE TRIGGER Trig1
  2. AFTER INSERT ON Highschooler
  3. when new.grade < 9 or new.grade > 12
  4. begin
  5. UPDATE Highschooler
  6. set grade = null
  7. where ID= new.ID;
  8. end;
  9.  
  10. |
  11.  
  12. CREATE TRIGGER Trig2
  13. AFTER INSERT ON Highschooler
  14. when new.grade = null
  15. begin
  16. UPDATE Highschooler
  17. set grade = 9
  18. where ID = new.ID;
  19. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement