tasklist_addstatustype.sql

来自「一个采用VS2008+Sql2000开发的任务管理系统」· SQL 代码 · 共 25 行

-- =============================================
-- TaskList_AddStatusType
-- =============================================
-- Adds a status type to the database
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_AddStatusType' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_AddStatusType
GO

CREATE PROCEDURE TaskList_AddStatusType
	@Description VarChar(25),
  @StatusFontFlags VarChar(500)
AS
DECLARE @SortOrder Integer

Select @SortOrder = Max(DefaultSortOrder) FROM TaskListStatus;
SET @SortOrder = @SortOrder + 1;

INSERT INTO TaskListStatus
(StatusDescription, StatusFontFlags, DefaultSortOrder)
VALUES
(@Description, @StatusFontFlags, @SortOrder)
RETURN @@Identity;