[dbo].[Forum_TemplatesUpdate]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@TemplateID	int	4
@TemplateName	nvarchar(50)	100
@TemplateValue	ntext	16
@IsActive	bit	1

SQL Script

CREATE PROCEDURE dbo.[Forum_TemplatesUpdate]
@TemplateID int,
@TemplateName nvarchar(50),
@TemplateValue ntext,
@IsActive bit
AS
UPDATE
    dbo.Forum_Templates
SET
    TemplateName = @TemplateName,
    TemplateValue = @TemplateValue,
    IsActive = @IsActive
WHERE
    TemplateID = @TemplateID

GO

Uses

[dbo].[Forum_Templates]
dbo