fnEmailRecipientIDByAddressBookIDEmailID

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@AddressBookID int IN
@EmailID int IN

Definition

Copy


CREATE FUNCTION dbo.fnEmailRecipientIDByAddressBookIDEmailID
    (    
    @AddressBookID int,
    @EmailID int
    )
    RETURNS int
    AS
    BEGIN
    RETURN (SELECT [ID] FROM [dbo].[Email_Recipient] 
        WHERE [AddressBookID]=@AddressBookID AND [EmailID] = @EmailID)
END