Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER KasaMechanika
- ON Zlecenia
- FOR INSERT UPDATE
- AS
- BEGIN
- IF EXISTS (SELECT m.Id_Mechanika FROM Mechanicy m, inserted i WHERE m.ID_Mechanika = i.ID_Mechanika AND
- m.Stwaka='0')
- BEGIN
- RAISERROR('***Mechanik nie będzie pracował za darmo***',16,1)
- ROLLBACK
- END
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement