Stored Procedures [dbo].[Forum_Bookmark_Threads_Check]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@UserIDint4
@ThreadIDint4
@ModuleIDint4
SQL Script


CREATE PROCEDURE dbo.[Forum_Bookmark_Threads_Check]
    (
      @UserID INT,
      @ThreadID INT,
      @ModuleID INT
    )
AS
    SELECT  COUNT(BookmarkID) AS Boolean
    FROM    dbo.Forum_Bookmark_Threads
    WHERE   UserID = @UserID
            AND ThreadID = @ThreadID
            AND ModuleID = @ModuleID

GO
Uses