Stored Procedures [dbo].[Forum_Group_Update]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@GroupIDint4
@Namenvarchar(255)510
@UpdatedByNamenvarchar(50)100
@SortOrderint4
@ModuleIDint4
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