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 dbo.sp_procesos_bdd_fisicas_score '1', '2017-11-30','20228354865','86.3'
CREATE OR ALTER PROCEDURE dbo.sp_procesos_bdd_fisicas_score
@id_cliente int,
@fecha_proceso date,
@cuit varchar(20),
@score decimal(10,2)
AS
BEGIN
SET NOCOUNT ON;
update procesos_bdd_fisicas
set score = @score
where cliente = @id_cliente
and fecha_proceso = @fecha_proceso
and cuit = @cuit
END
GO
GO
--EXEC dbo.sp_procesos_bdd_fisicas_score '1', '2017-11-30','20228354865','86.3'
CREATE OR ALTER PROCEDURE dbo.sp_procesos_bdd_fisicas_score
@id_cliente int,
@fecha_proceso date,
@cuit varchar(20),
@score decimal(10,2)
AS
BEGIN
SET NOCOUNT ON;
update procesos_bdd_fisicas
set score = @score
where cliente = @id_cliente
and fecha_proceso = @fecha_proceso
and cuit = @cuit
END
GO
Depends On
2Used By
No items found