Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
12| Name | Data Type | Length | Description |
|---|---|---|---|
| @anio | int | 4 | |
| @mes | varchar | 50 | |
| @periodo | varchar | 7 | |
| @country_code | varchar | 10 | |
| @country_name | varchar | 100 | |
| @lista_blanca | varchar | 50 | |
| @rating | varchar | 50 | |
| @dtf_global | varchar | 50 | |
| @footprint | varchar | 50 | |
| @visible | bit | 1 | |
| @desde | date | 3 | |
| @hasta | date | 3 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.Fuentes_LB_Footprint
@anio int,
@mes varchar(50),
@periodo varchar(7),
@country_code varchar(10),
@country_name varchar(100),
@lista_blanca varchar(50),
@rating varchar(50),
@dtf_global varchar(50),
@footprint varchar(50),
@visible bit,
@desde date,
@hasta date
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO LB_Footprint(anio, mes, periodo, country_code, country_name, lista_blanca, rating, dtf_global, footprint, visible, desde, hasta, created)
VALUES
(
@anio,
@mes,
@periodo,
@country_code,
@country_name,
@lista_blanca,
@rating,
@dtf_global,
@footprint,
@visible,
@desde,
@hasta,
GETDATE())
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.Fuentes_LB_Footprint
@anio int,
@mes varchar(50),
@periodo varchar(7),
@country_code varchar(10),
@country_name varchar(100),
@lista_blanca varchar(50),
@rating varchar(50),
@dtf_global varchar(50),
@footprint varchar(50),
@visible bit,
@desde date,
@hasta date
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO LB_Footprint(anio, mes, periodo, country_code, country_name, lista_blanca, rating, dtf_global, footprint, visible, desde, hasta, created)
VALUES
(
@anio,
@mes,
@periodo,
@country_code,
@country_name,
@lista_blanca,
@rating,
@dtf_global,
@footprint,
@visible,
@desde,
@hasta,
GETDATE())
END
GO
Depends On
1Used By
No items found