[dbo].[Forum_UserForumsUpdate]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserID	int	4
@ForumID	int	4
@LastVisitDate	datetime	8

SQL Script

CREATE PROCEDURE dbo.Forum_UserForumsUpdate
    @UserID int,
    @ForumID int,
    @LastVisitDate datetime
AS
    UPDATE Forum_UserForums
    SET
        LastVisitDate = @LastVisitDate
    WHERE
        UserID = @UserID
        AND
        ForumID = @ForumID

GO

Uses

[dbo].[Forum_UserForums]
dbo