Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
26| Name | Data Type | Length | Description |
|---|---|---|---|
| @ACTA | varchar | 150 | |
| @MARCA | varchar | 250 | |
| @TMARCA | varchar | 150 | |
| @TIPO | varchar | 150 | |
| @CLASE | varchar | 150 | |
| @NBOL | varchar | 150 | |
| @TEXP | varchar | 150 | |
| @PALABUS | varchar | 150 | |
| @FPRE | varchar | 150 | |
| @FPUBLI | varchar | 150 | |
| @TRESO | varchar | 150 | |
| @NRESO | varchar | 150 | |
| @FRESO | varchar | 150 | |
| @RENU_DE | varchar | 150 | |
| @RENU_POR | varchar | 150 | |
| @TITULAR | varchar | 250 | |
| @CODAGE | varchar | 150 | |
| @PAIS | varchar | 150 | |
| @COBERTURA | text | -1 | |
| @DISPCONCE | varchar | 150 | |
| @DISPBOLE | varchar | 150 | |
| @DISPFBOLE | varchar | 150 | |
| @PRIORIDAD | varchar | 150 | |
| @FPRIORIDAD | varchar | 150 | |
| @PPRIORIDAD | varchar | 150 | |
| @FVTO | varchar | 150 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.Fuentes_marcas
@ACTA varchar(150) = NULL,
@MARCA varchar(250) = NULL,
@TMARCA varchar(150) = NULL,
@TIPO varchar(150) = NULL,
@CLASE varchar(150) = NULL,
@NBOL varchar(150) = NULL,
@TEXP varchar(150) = NULL,
@PALABUS varchar(150) = NULL,
@FPRE varchar(150) = NULL,
@FPUBLI varchar(150) = NULL,
@TRESO varchar(150) = NULL,
@NRESO varchar(150) = NULL,
@FRESO varchar(150) = NULL,
@RENU_DE varchar(150) = NULL,
@RENU_POR varchar(150) = NULL,
@TITULAR varchar(250) = NULL,
@CODAGE varchar(150) = NULL,
@PAIS varchar(150) = NULL,
@COBERTURA text = NULL,
@DISPCONCE varchar(150) = NULL,
@DISPBOLE varchar(150) = NULL,
@DISPFBOLE varchar(150) = NULL,
@PRIORIDAD varchar(150) = NULL,
@FPRIORIDAD varchar(150) = NULL,
@PPRIORIDAD varchar(150) = NULL,
@FVTO varchar(150) = NULL
AS
BEGIN
SET NOCOUNT ON;
insert into marcas(ACTA,MARCA,TMARCA,TIPO,CLASE,NBOL,TEXP,PALABUS,FPRE,FPUBLI,TRESO,NRESO,FRESO,RENU_DE,RENU_POR,TITULAR,CODAGE,PAIS,COBERTURA,DISPCONCE,DISPBOLE,DISPFBOLE,PRIORIDAD,FPRIORIDAD,PPRIORIDAD,FVTO,modified)
values(
@ACTA,
@MARCA,
@TMARCA,
@TIPO,
@CLASE,
@NBOL,
@TEXP,
@PALABUS,
@FPRE,
@FPUBLI,
@TRESO,
@NRESO,
@FRESO,
@RENU_DE,
@RENU_POR,
@TITULAR,
@CODAGE,
@PAIS,
@COBERTURA,
@DISPCONCE,
@DISPBOLE,
@DISPFBOLE,
@PRIORIDAD,
@FPRIORIDAD,
@PPRIORIDAD,
@FVTO,
GETDATE())
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.Fuentes_marcas
@ACTA varchar(150) = NULL,
@MARCA varchar(250) = NULL,
@TMARCA varchar(150) = NULL,
@TIPO varchar(150) = NULL,
@CLASE varchar(150) = NULL,
@NBOL varchar(150) = NULL,
@TEXP varchar(150) = NULL,
@PALABUS varchar(150) = NULL,
@FPRE varchar(150) = NULL,
@FPUBLI varchar(150) = NULL,
@TRESO varchar(150) = NULL,
@NRESO varchar(150) = NULL,
@FRESO varchar(150) = NULL,
@RENU_DE varchar(150) = NULL,
@RENU_POR varchar(150) = NULL,
@TITULAR varchar(250) = NULL,
@CODAGE varchar(150) = NULL,
@PAIS varchar(150) = NULL,
@COBERTURA text = NULL,
@DISPCONCE varchar(150) = NULL,
@DISPBOLE varchar(150) = NULL,
@DISPFBOLE varchar(150) = NULL,
@PRIORIDAD varchar(150) = NULL,
@FPRIORIDAD varchar(150) = NULL,
@PPRIORIDAD varchar(150) = NULL,
@FVTO varchar(150) = NULL
AS
BEGIN
SET NOCOUNT ON;
insert into marcas(ACTA,MARCA,TMARCA,TIPO,CLASE,NBOL,TEXP,PALABUS,FPRE,FPUBLI,TRESO,NRESO,FRESO,RENU_DE,RENU_POR,TITULAR,CODAGE,PAIS,COBERTURA,DISPCONCE,DISPBOLE,DISPFBOLE,PRIORIDAD,FPRIORIDAD,PPRIORIDAD,FVTO,modified)
values(
@ACTA,
@MARCA,
@TMARCA,
@TIPO,
@CLASE,
@NBOL,
@TEXP,
@PALABUS,
@FPRE,
@FPUBLI,
@TRESO,
@NRESO,
@FRESO,
@RENU_DE,
@RENU_POR,
@TITULAR,
@CODAGE,
@PAIS,
@COBERTURA,
@DISPCONCE,
@DISPBOLE,
@DISPFBOLE,
@PRIORIDAD,
@FPRIORIDAD,
@PPRIORIDAD,
@FVTO,
GETDATE())
END
GO
Depends On
1Used By
No items found