UFN_APPUSERCLAIMS_ISREGISTERED

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_APPUSERCLAIMS_ISREGISTERED
      (
        @APPUSERID uniqueidentifier
      )
      returns bit
      with execute as caller
      as 
      begin
        if exists (select 1 from dbo.APPUSERCLAIMSLINK where APPUSERID = @APPUSERID)
                   and not exists (select 1 from dbo.APPUSERCLAIMS where APPUSERID = @APPUSERID)
        begin
          return (select ISREGISTERED from dbo.APPUSERCLAIMSLINK where APPUSERID = @APPUSERID);
        end

        return (select ISREGISTERED from dbo.APPUSERCLAIMS where APPUSERID = @APPUSERID);
      end