Stored Procedures [dbo].[Forum_Permissions_GetCollection]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ForumIDint4
@PermissionIDint4
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