[dbo].[Forum_EmailQueue_TaskCleanEmails]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@DeleteDate	datetime	8

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailQueue_TaskCleanEmails]
@DeleteDate datetime
AS

DELETE
FROM
dbo.Forum_EmailQueue_TaskEmails
WHERE
DateAdded < @DeleteDate

GO

Uses

[dbo].[Forum_EmailQueue_TaskEmails]
dbo