USP_DATAFORMTEMPLATE_EDITLOAD_ETICKETSPARTSETTINGS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SITECONTENTID	int	INOUT
@PRINTBUTTONTEXT	nvarchar(max)	INOUT
@TICKETSTEXT	nvarchar(max)	INOUT
@FOOTERTEXT	nvarchar(max)	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ETICKETSPARTSETTINGS (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @SITECONTENTID int = null output,
    @PRINTBUTTONTEXT nvarchar(max) = null output,
    @TICKETSTEXT nvarchar(max) = null output,
    @FOOTERTEXT nvarchar(max) = null output
)
as

    set nocount on;

    -- setting @DATALOADED because it's okay if the ID returns nothing
    set @DATALOADED = 1
    set @TSLONG = 0

    select
        @TSLONG = [TSLONG],
        @SITECONTENTID = [SITECONTENTID],
        @PRINTBUTTONTEXT = [PRINTBUTTONTEXT],
        @TICKETSTEXT = [TICKETSTEXT],
        @FOOTERTEXT = [FOOTERTEXT]
    from dbo.[ETICKETSPARTSETTINGS] with (nolock)
    where ID = @ID

    return 0;