usp_updategroup.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE PROCEDURE usp_UpdateGroup
(
   @GroupName          VARCHAR(50),
   @GroupDescription   TEXT,
   @GroupID            UNIQUEIDENTIFIER
)
AS
UPDATE Groups 
SET GroupName = @GroupName, 
    GroupDescription = @GroupDescription, 
    LastUpdateDate = GETDATE()
WHERE GroupID = @GroupID