Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_num_documento | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- =============================================
-- Author: <Patricio Lecolant>
-- Create date: <18 junio 2019>
-- Description: <Obtiene sub productos dossier por numero de documento>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.dossier_obtener_sub_productos
@p_num_documento int
AS
BEGIN
SET NOCOUNT ON;
select * from sub_productos_dossier where num_documento = @p_num_documento
END
GO
GO
-- =============================================
-- Author: <Patricio Lecolant>
-- Create date: <18 junio 2019>
-- Description: <Obtiene sub productos dossier por numero de documento>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.dossier_obtener_sub_productos
@p_num_documento int
AS
BEGIN
SET NOCOUNT ON;
select * from sub_productos_dossier where num_documento = @p_num_documento
END
GO
Depends On
1Used By
No items found