usp_updateproject.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 15 行

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