[dbo].[Forum_TemplatesAddForModuleID]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@TemplateName	nvarchar(50)	100
@TemplateValue	ntext	16
@ForumTemplateTypeID	int	4
@ModuleID	int	4
@IsActive	int	4

SQL Script

/* END Data Insert */

CREATE PROCEDURE dbo.[Forum_TemplatesAddForModuleID]
@TemplateName nvarchar(50),
@TemplateValue ntext,
@ForumTemplateTypeID int,
@ModuleID int,
@IsActive int
AS
INSERT INTO
    dbo.Forum_Templates
    (
    TemplateName,
    TemplateValue,
    ForumTemplateTypeID,
    ModuleID,
    IsActive
    )
VALUES
    (
    @TemplateName,
    @TemplateValue,
    @ForumTemplateTypeID,
    @ModuleID,
    @IsActive
    )
SELECT SCOPE_IDENTITY()

GO

Uses

[dbo].[Forum_Templates]
dbo