[dbo].[Forum_EmailTemplateForModuleIDAdd]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@ForumTemplateTypeID	int	4
@EmailSubject	nvarchar(50)	100
@HTMLBody	ntext	16
@TextBody	ntext	16
@ModuleID	int	4
@IsActive	int	4
@ForumContentTypeID	int	4
@EmailTemplateName	nvarchar(50)	100
@ForumEmailTypeID	int	4

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailTemplateForModuleIDAdd]
@ForumTemplateTypeID int,
@EmailSubject nvarchar(50),
@HTMLBody ntext,
@TextBody ntext,
@ModuleID int,
@IsActive int,
@ForumContentTypeID int,
@EmailTemplateName nvarchar(50),
@ForumEmailTypeID int
AS
INSERT INTO
    dbo.Forum_EmailTemplates
    (
    ForumTemplateTypeID,
    EmailSubject,
    HTMLBody,
    TextBody,
    ModuleID,
    IsActive,
    ForumContentTypeID,
    EmailTemplateName,
    ForumEmailTypeID
    )
VALUES
    (
    @ForumTemplateTypeID,
    @EmailSubject,
    @HTMLBody,
    @TextBody,
    @ModuleID,
    @IsActive,
    @ForumContentTypeID,
    @EmailTemplateName,
    @ForumEmailTypeID
    )
SELECT SCOPE_IDENTITY()

GO