[dbo].[Forum_ThreadRating_GetUser]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_ThreadRating_GetUser
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@ThreadID
int
4
@UserID
int
4
SQL Script
CREATE
PROCEDURE
dbo.
[Forum_ThreadRating_GetUser]
@ThreadID
INT
,
@UserID
INT
AS
BEGIN
SELECT
Rate
FROM
dbo.Forum_ThreadRating
WHERE
ThreadID
=
@ThreadID
AND
UserID
=
@UserID
END
GO
Uses
[dbo].[Forum_ThreadRating]
dbo