UFN_GET_EVENTAPPEALID_BY_EMAILID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@EMAILID	int	IN

Definition

Copy



        CREATE function dbo.UFN_GET_EVENTAPPEALID_BY_EMAILID(@EMAILID int)
        returns int
        with execute as caller
        as begin
            return (select top 1 APPEALID from dbo.EMAIL where ID =@EMAILID)
        end