usp_insertproject.sql

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

CREATE PROCEDURE usp_InsertProject
(
   @ProjectID            UNIQUEIDENTIFIER,
   @ProjectName          VARCHAR(50),
   @ProjectDescription   TEXT,
   @SequenceNumber       TINYINT 
)
AS
INSERT INTO Projects 
   (ProjectID, ProjectName, ProjectDescription, SequenceNumber, 
      LastUpdateDate)
   VALUES(@ProjectID, @ProjectName, @ProjectDescription, @SequenceNumber, 
      GETDATE())