Guest User

Untitled

a guest
May 21st, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. CREATE TRIGGER tr_update_vlucht
  2. ON vlucht
  3. AFTER UPDATE
  4. AS
  5. IF @@ROWCOUNT = 0
  6. RETURN
  7.  
  8. BEGIN TRY
  9. IF EXISTS(SELECT 1 FROM passagier P INNER JOIN Deleted D ON P.vlucht = D.vluchtnummer)
  10. BEGIN
  11. ROLLBACK TRANSACTION
  12. RAISERROR('Er zijn al passagiers aan deze vlucht toegewezen.
  13. Vlucht informatie kan niet meer veranderd worden.', 16, 1)
  14. RETURN
  15. END
  16. END TRY
  17. BEGIN CATCH
  18. SELECT ERROR_NUMBER() AS ErrorNumber ,ERROR_MESSAGE() AS ErrorMessage;
  19. END CATCH
Add Comment
Please, Sign In to add comment