USP_DATALIST_DEFAULTEMAILTEXT

Gets the default text for an email.

Parameters

Parameter Parameter Type Mode Description
@EMAILTYPE varchar(50) IN Email Type

Definition

Copy


          CREATE procedure [dbo].[USP_DATALIST_DEFAULTEMAILTEXT]
          (
            @EMAILTYPE as varchar(50)
          )
          as
            select
              [Value]
            from
              dbo.DefaultText
            where
              TemplateName = @EMAILTYPE;