Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
5| Name | Data Type | Length | Description |
|---|---|---|---|
| @user_id | int | 4 | |
| @vigencia_desde | smalldatetime | 4 | |
| @vigencia_hasta | smalldatetime | 4 | |
| @task_id | int | 4 | |
| @tipo | varchar | 50 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*
select * from users where username = 'Sistemas'
exec [agregar_tarea] '94437923','0',
'27272089251','94437923','2017-08-11','2017-08-25','balance'
*/
CREATE OR ALTER PROCEDURE dbo.modificar_tarea
@user_id int,
@vigencia_desde smalldatetime,
@vigencia_hasta smalldatetime,
@task_id int,
@tipo varchar(50)
AS
BEGIN
update tareas_usuarios_documentos
set user_id = @user_id,
vigencia_desde = @vigencia_desde,
vigencia_hasta = @vigencia_hasta
where task_id = @task_id
END
GO
GO
/*
select * from users where username = 'Sistemas'
exec [agregar_tarea] '94437923','0',
'27272089251','94437923','2017-08-11','2017-08-25','balance'
*/
CREATE OR ALTER PROCEDURE dbo.modificar_tarea
@user_id int,
@vigencia_desde smalldatetime,
@vigencia_hasta smalldatetime,
@task_id int,
@tipo varchar(50)
AS
BEGIN
update tareas_usuarios_documentos
set user_id = @user_id,
vigencia_desde = @vigencia_desde,
vigencia_hasta = @vigencia_hasta
where task_id = @task_id
END
GO
Depends On
1Used By
No items found