spAddUpdate_EmailTemplate

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@UserID	int	IN
@ClientsID	int	IN
@Name	nvarchar(92)	IN
@Description	nvarchar(255)	IN
@ContentHTML	ntext	IN
@RecipientListsXML	nvarchar(4000)	IN
@ContentText	ntext	IN
@FromAddress	nvarchar(255)	IN
@FromDisplayName	nvarchar(255)	IN
@Subject	nvarchar(4000)	IN
@Priority	int	IN
@ReplyAddress	nvarchar(255)	IN
@ReturnReceipt	bit	IN
@ReturnReceiptAddress	nvarchar(255)	IN
@ForwardDSN	bit	IN
@ForwardDSNAddress	nvarchar(255)	IN
@GUID	uniqueidentifier	INOUT
@Type	tinyint	IN
@DataSourceID	int	IN
@ClientSitesID	int	IN
@AppealID	int	IN
@ExportDefinitionID	uniqueidentifier	IN
@EmailAddressTypeID	uniqueidentifier	IN
@IsExcludeInactiveRecipient	bit	IN
@InactiveRecipientFromMonths	int	IN
@AlternateSubject	nvarchar(255)	IN

Definition

Copy



 CREATE PROCEDURE [dbo].[spAddUpdate_EmailTemplate]
(
    @PKID int OUTPUT,
    @UserID    int,
    @ClientsID int,
    @Name nvarchar(92),
    @Description nvarchar(255),
    @ContentHTML ntext,
    @RecipientListsXML nvarchar(4000),
    @ContentText ntext,
    @FromAddress nvarchar(255),
    @FromDisplayName nvarchar(255),
    @Subject nvarchar(4000),
    @Priority int,
    @ReplyAddress nvarchar(255),
    @ReturnReceipt bit,
    @ReturnReceiptAddress nvarchar(255),
    @ForwardDSN bit,
    @ForwardDSNAddress nvarchar(255),
    @GUID uniqueidentifier OUTPUT,
    @Type tinyint,
    @DataSourceID int,
    @ClientSitesID int,
    @AppealID int = null,
    @ExportDefinitionID uniqueidentifier = null,
    @EmailAddressTypeID uniqueidentifier = null    ,
  @IsExcludeInactiveRecipient bit = 0,
  @InactiveRecipientFromMonths int = 0,
  @AlternateSubject nvarchar(255) = null

)
AS
/*this proc is obsolete, replaced by USP_EMAILTEMPLATE_ADDUPDATE. leaving this 
for legacy code*/
exec USP_EMAILTEMPLATE_ADDUPDATE @PKID output,
    @UserID,
    @ClientsID,
    @Name,
    @Description,
    @ContentHTML,
    @RecipientListsXML,
    @ContentText,
    @FromAddress,
    @FromDisplayName,
    @Subject,
    @Priority,
    @ReplyAddress,
    @ReturnReceipt,
    @ReturnReceiptAddress,
    @ForwardDSN,
    @ForwardDSNAddress,
    @GUID output,
    @Type,
    @DataSourceID,
    @ClientSitesID,
    @AppealID,
    @ExportDefinitionID,
    @EmailAddressTypeID,
  @IsExcludeInactiveRecipient,
  @InactiveRecipientFromMonths,
    @AlternateSubject