[dbo].[Forum_EmailTemplatesByModuleAndTypeGet]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_EmailTemplatesByModuleAndTypeGet

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ModuleID	int	4
@ForumEmailTypeID	int	4

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailTemplatesByModuleAndTypeGet]
@ModuleID int,
@ForumEmailTypeID int
AS
SELECT
    EmailTemplateID,
    ForumTemplateTypeID,
    EmailSubject,
    HTMLBody,
    TextBody,
    ModuleID,
    IsActive,
    ForumContentTypeID,
    ForumEmailTypeID
FROM
    Forum_EmailTemplates
WHERE
    ModuleID = @ModuleID
AND
    ForumEmailTypeID = @ForumEmailTypeID

GO

Uses

[dbo].[Forum_EmailTemplates]
dbo