usp_updateproject.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE PROCEDURE usp_UpdateProject
(
   @ProjectName          VARCHAR(50),
   @ProjectDescription   TEXT,
   @SequenceNumber       TINYINT,
   @ProjectID            UNIQUEIDENTIFIER
)
AS
UPDATE Projects 
SET ProjectName = @ProjectName, 
    ProjectDescription = @ProjectDescription, 
    SequenceNumber = @SequenceNumber, 
    LastUpdateDate = GETDATE()
WHERE ProjectID = @ProjectID