Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. USE [bases]
  2. GO
  3. /****** Object: Trigger [dbo].[restrinccion] Script Date: 19/02/2019 11:09:18 a. m. ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. ALTER TRIGGER [dbo].[restrinccion]
  9. ON [dbo].[tblencfacturas]
  10. FOR INSERT
  11. AS
  12. DECLARE @consecutivo CHAR(20)
  13.  
  14. IF (@consecutivo>=1070039333) BEGIN
  15. RAISERROR ('No se puede realizar la Factura, restrinccion sistemas.',
  16. -- Message text.
  17. 16, -- Severity.
  18. 1 -- State.
  19. )
  20. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement