Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.29 KB | None | 0 0
  1. create trigger ValidateAge on Cliente for insert,update
  2. as
  3. declare @age integer
  4. select @age = i.Age from inserted i
  5. if(@age <=20)
  6.     begin
  7.         commit tran
  8.         select'Se ingreso el alumno' as mensaje
  9.     end
  10. else
  11.     begin
  12.         rollback tran
  13.         select'no se aceptan mayores de 20 años' as mensaje
  14.     end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement