[dbo].[Forum_TemplatesGetByType]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

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

SQL Script

CREATE PROCEDURE dbo.[Forum_TemplatesGetByType]
@ModuleID int,
@ForumTemplateTypeID int
AS
SELECT
    TemplateID,
    TemplateName
FROM
    dbo.Forum_Templates
WHERE
    ModuleID = @ModuleID
AND
    ForumTemplateTypeID = @ForumTemplateTypeID
AND
    IsActive = 1

GO

Uses

[dbo].[Forum_Templates]
dbo