[dbo].[Forum_UserThreadsGet]

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

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

SQL Script

CREATE PROCEDURE dbo.Forum_UserThreadsGet
    @UserID int,
    @ThreadID int
AS
SELECT
    UserID,
    ThreadID,
    LastVisitDate
FROM
    Forum_UserThreads
WHERE
    UserID=@UserID
    AND
    ThreadID=@ThreadID

GO

Uses

[dbo].[Forum_UserThreads]
dbo