[dbo].[Forum_UserForumsGet]

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

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

SQL Script

CREATE PROCEDURE dbo.[Forum_UserForumsGet]
    @UserID INT,
    @ForumID INT
AS
    SELECT  UF.[UserID],
            UF.[ForumID],
            UF.[LastVisitDate]
    FROM    dbo.Forum_UserForums UF
    WHERE   UF.[UserID] = @UserID
            AND UF.[ForumID] = @ForumID

GO

Uses

[dbo].[Forum_UserForums]
dbo