USP_DATAFORMTEMPLATE_VIEW_APPUSERLINKAUTHUSERPAGE

Parameters

Parameter Parameter Type Mode Description
@DATALOADED bit INOUT
@SKYACCESSKEYEXISTS bit INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPUSERLINKAUTHUSERPAGE
(
    @DATALOADED bit = 0 output,
    @SKYACCESSKEYEXISTS bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @SKYACCESSKEYEXISTS = case when exists(select 1 from dbo.SKYACCESS where SKYACCESSKEY <> '') then 1 else 0 end;

    return 0;