Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
4| Name | Data Type | Length | Description |
|---|---|---|---|
| @id_cliente | int | 4 | |
| @fecha_proceso | date | 3 | |
| @cuit | varchar | 20 | |
| @score | decimal | 9 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
--exec sp_procesos_cuit_score '452189004', '2017-09-14', '20012577835', '70.0'
CREATE OR ALTER PROCEDURE dbo.sp_procesos_cuit_score
@id_cliente int,
@fecha_proceso date,
@cuit varchar(20),
@score decimal(10,2)
AS
BEGIN
SET NOCOUNT ON;
update procesos_cuit_enrichment
set score = @score
where cliente = @id_cliente
and fecha_proceso = @fecha_proceso
and cuit = @cuit
END
GO
GO
--exec sp_procesos_cuit_score '452189004', '2017-09-14', '20012577835', '70.0'
CREATE OR ALTER PROCEDURE dbo.sp_procesos_cuit_score
@id_cliente int,
@fecha_proceso date,
@cuit varchar(20),
@score decimal(10,2)
AS
BEGIN
SET NOCOUNT ON;
update procesos_cuit_enrichment
set score = @score
where cliente = @id_cliente
and fecha_proceso = @fecha_proceso
and cuit = @cuit
END
GO
Depends On
2Used By
No items found