[dbo].[Forum_Permissions_UpdateForum]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_Permissions_UpdateForum
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@ForumPermissionID
int
4
@ForumID
int
4
@PermissionID
int
4
@RoleID
int
4
@AllowAccess
bit
1
@UserID
int
4
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
[dbo].[Forum_ForumPermission]
dbo