Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- DROP TRIGGER ValidarCantidadMaterialesEnEntregaEsMayorACero
- CREATE TRIGGER ValidarCantidadMaterialesEnEntregaEsMayorACero ON entregas FOR INSERT AS
- DECLARE @cantidad INT = (SELECT cantidad FROM inserted)
- IF @cantidad <= 0
- BEGIN
- ROLLBACK TRAN
- PRINT 'La cantidad del material entregado debe ser mayor a cero'
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement