USP_DATAFORMTEMPLATE_VIEW_EVENT_PUBLICDESCRIPTION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@PUBLICDESCRIPTIONHTML	nvarchar(max)	INOUT

Definition

Copy


                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENT_PUBLICDESCRIPTION
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @PUBLICDESCRIPTIONHTML nvarchar(max) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @PUBLICDESCRIPTIONHTML = [EVENT].[PUBLICDESCRIPTIONHTML]
                    from dbo.[EVENT]
                    where [EVENT].[ID] = @ID

                return 0;