[dbo].[Forum_EmailTemplateUpdate]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@EmailTemplateID	int	4
@EmailSubject	nvarchar(50)	100
@HTMLBody	ntext	16
@TextBody	ntext	16
@IsActive	bit	1

SQL Script

CREATE PROCEDURE dbo.Forum_EmailTemplateUpdate
@EmailTemplateID int,
@EmailSubject nvarchar(50),
@HTMLBody ntext,
@TextBody ntext,
@IsActive bit
AS
UPDATE
    dbo.Forum_EmailTemplates
SET
    EmailSubject = @EmailSubject,
    HTMLBody = @HTMLBody,
    TextBody = @TextBody,
    IsActive = @IsActive
WHERE
    EmailTemplateID = @EmailTemplateID

GO

Uses

[dbo].[Forum_EmailTemplates]
dbo