USP_DATAFORMTEMPLATE_VIEW_ADUEXPORTPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@OUTPUTPATH	nvarchar(1024)	INOUT
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT
@PARAMETERSID	uniqueidentifier	INOUT

Definition

Copy



                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ADUEXPORTPROCESS(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @OUTPUTPATH nvarchar(1024) = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @PARAMETERSID uniqueidentifier = null output)
                with execute as caller
                as
                    set nocount on;

                    begin try
                        set @DATALOADED = 0

                        select 
                            @DATALOADED = 1,
                            @PARAMETERSID = ADUEXPORTPROCESS.ID,
                            @NAME = ADUEXPORTPROCESS.NAME,
                            @DESCRIPTION = ADUEXPORTPROCESS.DESCRIPTION,
                            @OUTPUTPATH = ADUEXPORTPROCESS.OUTPUTPATH,
                            @BUSINESSPROCESSCATALOGID = 'C562312D-CDAC-4894-AFCA-878F79B9EC20'
                        from 
                            dbo.ADUEXPORTPROCESS
                        where 
                            ADUEXPORTPROCESS.ID = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch;

                    return 0;