USP_DATAFORMTEMPLATE_VIEW_EVENTWORKCENTER_APPUSERSITE

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@DATALOADED bit INOUT
@SITEID uniqueidentifier INOUT

Definition

Copy

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTWORKCENTER_APPUSERSITE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @SITEID uniqueidentifier = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
           @DATALOADED = 1,
           @SITEID = SITEID
    from 
        dbo.APPUSER
    where 
        ID = @ID

    return 0;