[dbo].[Forum_EmailQueue_TaskEmailsSendStatusUpdate]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@EmailQueueID	int	4
@EmailAddress	nvarchar(100)	200
@Failed	bit	1

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailQueue_TaskEmailsSendStatusUpdate]
@EmailQueueID int,
@EmailAddress nvarchar(100),
@Failed bit
AS
UPDATE dbo.Forum_EmailQueue_TaskEmails
SET
    IsComplete = 1,
    DateComplete = GetDate(),
    Failed = @Failed
WHERE
    EmailQueueID = @EmailQueueID
AND
    EmailAddress = @EmailAddress

GO

Uses

[dbo].[Forum_EmailQueue_TaskEmails]
dbo