[dbo].[Forum_Post_Reported_GetDetail]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_Post_Reported_GetDetail
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@PostID
int
4
SQL Script
CREATE
PROCEDURE
dbo.Forum_Post_Reported_GetDetail
@PostID
INT
AS
SELECT
PostReportedID
,
CreatedDate
,
PostID
,
UserID
,
Reason
,
Addressed
FROM
dbo.Forum_Post_Reported
WHERE
PostID
=
@PostID
ORDER
BY
CreatedDate
DESC
GO
Uses
[dbo].[Forum_Post_Reported]
dbo