Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Null on Null Input | False |
| Schema Bound | False |
| Assembly |
Parameters
2| Name | Data Type | Length | Description |
|---|---|---|---|
| (Result) | TABLE | max | |
| @tarea | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER FUNCTION dbo.GetInformeByTarea(@tarea int)
RETURNS TABLE
AS
RETURN
(
SELECT
INF.informe,
INF.id_tipo_informe,
INF.estado_informe
FROM informes as Tareas
INNER JOIN informes as INF ON INF.informe=Tareas.informe_padre
WHERE Tareas.informe=@tarea
);
GO
GO
CREATE OR ALTER FUNCTION dbo.GetInformeByTarea(@tarea int)
RETURNS TABLE
AS
RETURN
(
SELECT
INF.informe,
INF.id_tipo_informe,
INF.estado_informe
FROM informes as Tareas
INNER JOIN informes as INF ON INF.informe=Tareas.informe_padre
WHERE Tareas.informe=@tarea
);
GO