[dbo].[Forum_UserThreadsUpdate]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

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

SQL Script

CREATE PROCEDURE dbo.Forum_UserThreadsUpdate
    @UserID int,
    @ThreadID int,
    @LastVisitDate datetime
AS
UPDATE
    Forum_UserThreads
SET
    LastVisitDate = @LastVisitDate
WHERE
    UserID = @UserID
    AND
    ThreadID = @ThreadID

GO

Uses

[dbo].[Forum_UserThreads]
dbo