Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
2| Name | Data Type | Length | Description |
|---|---|---|---|
| @task_id | int | 4 | |
| @tipo_tarea | varchar | 50 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.borrar_tarea
@task_id int,
@tipo_tarea varchar(50) = 'balance'
AS
BEGIN
delete from tareas_usuarios_documentos where task_id = @task_id
if (@tipo_tarea = 'balance')
begin
--delete from balances_contables where task_id = @task_id
update balances_contables set estado = 0, visible = 0 where task_id = @task_id
end
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.borrar_tarea
@task_id int,
@tipo_tarea varchar(50) = 'balance'
AS
BEGIN
delete from tareas_usuarios_documentos where task_id = @task_id
if (@tipo_tarea = 'balance')
begin
--delete from balances_contables where task_id = @task_id
update balances_contables set estado = 0, visible = 0 where task_id = @task_id
end
END
GO
Depends On
2Used By
No items found