Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER tr_update_vlucht
- ON vlucht
- AFTER UPDATE
- AS
- IF @@ROWCOUNT = 0
- RETURN
- BEGIN TRY
- IF EXISTS(SELECT 1 FROM passagier P INNER JOIN Deleted D ON P.vlucht = D.vluchtnummer)
- BEGIN
- ROLLBACK TRANSACTION
- RAISERROR('Er zijn al passagiers aan deze vlucht toegewezen.
- Vlucht informatie kan niet meer veranderd worden.', 16, 1)
- RETURN
- END
- END TRY
- BEGIN CATCH
- SELECT ERROR_NUMBER() AS ErrorNumber ,ERROR_MESSAGE() AS ErrorMessage;
- END CATCH
Add Comment
Please, Sign In to add comment