[dbo].[Forum_Permissions_GetCollection]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_Permissions_GetCollection
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@ForumID
int
4
@PermissionID
int
4
SQL Script
CREATE
PROCEDURE
dbo.
[Forum_Permissions_GetCollection]
@ForumID
INT
,
@PermissionID
INT
AS
SELECT
*
FROM
dbo.Forum_vw_ForumPermissions
WHERE
(
@ForumID
=
-
1
OR
ForumID
=
@ForumID
)
AND
(
PermissionID
=
@PermissionID
OR
@PermissionID
=
-
1
)
GO
Uses
[dbo].[Forum_vw_ForumPermissions]
dbo