Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDUREdbo.Facturacion_enc_pedido
AS
BEGIN
SET NOCOUNT ON;
declare @nro_pedido int =
(select isnull(max(fac_nro_pedido),0) + 1 as nro_pedido
from facturacion_enc)
insert into facturacion_enc (fac_nro_pedido) values (@nro_pedido)
select @nro_pedido as nro_pedido
END
GO
GO
CREATE OR ALTER PROCEDUREdbo.Facturacion_enc_pedido
AS
BEGIN
SET NOCOUNT ON;
declare @nro_pedido int =
(select isnull(max(fac_nro_pedido),0) + 1 as nro_pedido
from facturacion_enc)
insert into facturacion_enc (fac_nro_pedido) values (@nro_pedido)
select @nro_pedido as nro_pedido
END
GO
Depends On
1Used By
No items found