USP_EMAILTEMPLATEHTML_GETDATA

Returns the html content of an email template

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Id

Definition

Copy



        CREATE procedure dbo.USP_EMAILTEMPLATEHTML_GETDATA
        ( @ID uniqueidentifier)
        as
        set nocount on;

        select EmailTemplate.ContentHTML
        from dbo.EmailTemplate
        where EmailTemplate.Guid = @ID