UFN_APPUSER_GETALERTEMAILADDRESS

Returns the email address of an app user to which alerts should be sent.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_APPUSER_GETALERTEMAILADDRESS (
                @APPUSERID uniqueidentifier
            ) returns nvarchar(100) as 
            begin

                declare @EMAILADDRESS nvarchar(100);

                select top(1)
                    @EMAILADDRESS = EMAILADDRESS
                from
                    dbo.APPUSERALERTSETTING
                where
                    ID = @APPUSERID;

                return @EMAILADDRESS;
            end