USP_BBNC_GETEMAILBYID

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_BBNC_GETEMAILBYID
(
@ID uniqueidentifier = null
)
as
begin
    select 
    CONSTITUENTID,
    EMAILADDRESSTYPECODEID,
    EMAILADDRESS,
    ISPRIMARY
  from
    dbo.EMAILADDRESS
  where
    ID = @ID
end