Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create trigger ValidateAge on Cliente for insert,update
- as
- declare @age integer
- select @age = i.Age from inserted i
- if(@age <=20)
- begin
- commit tran
- select'Se ingreso el alumno' as mensaje
- end
- else
- begin
- rollback tran
- select'no se aceptan mayores de 20 años' as mensaje
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement