[dbo].[Forum_Bookmark_Threads_Check]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_Bookmark_Threads_Check
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@UserID
int
4
@ThreadID
int
4
@ModuleID
int
4
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
[dbo].[Forum_Bookmark_Threads]
dbo