[dbo].[Forum_TemplatesGetDefaults]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

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

SQL Script

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

GO

Uses

[dbo].[Forum_Templates]
dbo