[dbo].[Forum_Group_Update]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_Group_Update
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@GroupID
int
4
@Name
nvarchar(255)
510
@UpdatedByName
nvarchar(50)
100
@SortOrder
int
4
@ModuleID
int
4
SQL Script
CREATE
PROCEDURE
dbo.
[Forum_Group_Update]
@GroupID
INT
,
@Name
NVARCHAR
(
255
),
@UpdatedByName
NVARCHAR
(
50
),
@SortOrder
INT
,
@ModuleID
INT
AS
UPDATE
dbo.Forum_Groups
SET
[Name]
=
@Name
,
[UpdatedByUser]
=
@UpdatedByName
,
[UpdatedDate]
=
GETDATE
(),
[SortOrder]
=
@SortOrder
WHERE
[GroupID]
=
@GroupID
AND
ModuleID
=
@ModuleID
GO
Uses
[dbo].[Forum_Groups]
dbo