UFN_GET_CIPHER_BY_USERID

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN

Definition

Copy



        create function dbo.UFN_GET_CIPHER_BY_USERID(@ID as int)
        returns nvarchar(max)
        with execute as caller
        as begin
            declare @CIPHER nvarchar(max)
          select @CIPHER = CIPHER from dbo.CLIENTUSERSCIPHER where CLIENTUSERSID = @ID;
          return @CIPHER    
        end