Stored Procedures [dbo].[Forum_Permissions_UpdateForum]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ForumPermissionIDint4
@ForumIDint4
@PermissionIDint4
@RoleIDint4
@AllowAccessbit1
@UserIDint4
SQL Script


CREATE PROCEDURE dbo.[Forum_Permissions_UpdateForum]
    @ForumPermissionID INT,
    @ForumID INT,
    @PermissionID INT,
    @RoleID INT,
    @AllowAccess BIT,
    @UserID INT
AS
    UPDATE  dbo.Forum_ForumPermission
    SET     [ForumID] = @ForumID,
            [PermissionID] = @PermissionID,
            [RoleID] = @RoleID,
            [AllowAccess] = @AllowAccess,
            [UserID] = @UserID
    WHERE   [ForumPermissionID] = @ForumPermissionID

GO
Uses