USP_DATAFORMTEMPLATE_VIEW_REGISTRATIONINFORMATION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@TYPECODE	tinyint	INOUT
@RESPONSETYPECODE	tinyint	INOUT
@INACTIVE	bit	INOUT
@ASKPERSONPHONE2	bit	INOUT
@ASKPERSONEMAIL	bit	INOUT
@ONLINEHTML	nvarchar(max)	INOUT
@DISPLAYONLINE	bit	INOUT
@ALLPRICETYPES	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REGISTRATIONINFORMATION (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,

    @NAME nvarchar(100) = null output,
    @TYPECODE tinyint = null output,
    @RESPONSETYPECODE tinyint = null output,
    @INACTIVE bit = null output,
    @ASKPERSONPHONE2 bit = null output,
    @ASKPERSONEMAIL bit = null output,
    @ONLINEHTML nvarchar(max) = null output,
    @DISPLAYONLINE bit = null output,
    @ALLPRICETYPES bit = null output
) as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,

        @NAME = NAME,
        @TYPECODE = TYPECODE,
        @RESPONSETYPECODE = RESPONSETYPECODE,
        @INACTIVE = INACTIVE,
        @ASKPERSONPHONE2 = ASKPERSONPHONE2,
        @ASKPERSONEMAIL = ASKPERSONEMAIL    ,
        @ONLINEHTML = ONLINEHTML,
        @DISPLAYONLINE = DISPLAYONLINE,
        @ALLPRICETYPES = ALLPRICETYPES

    from dbo.REGISTRATIONINFORMATION
    where ID = @ID

    return 0;