USP_DATALIST_EMAILADDRESSBYADDRESS
Returns email address records that match the specified email address.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILADDRESS | UDT_EMAILADDRESS | IN | Email Address |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_EMAILADDRESSBYADDRESS(@EMAILADDRESS UDT_EMAILADDRESS)
as
set nocount on;
select EA.ID, EA.CONSTITUENTID
from dbo.EMAILADDRESS EA
where EA.EMAILADDRESS = @EMAILADDRESS