tasklist_updatestatustype.sql

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

-- =============================================
-- TaskList_UpdateStatusType
-- =============================================
-- creating the store procedure
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_UpdateStatusType' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_UpdateStatusType
GO

CREATE PROCEDURE TaskList_UpdateStatusType
  @StatusID BigInt,
	@Description VarChar(25),
  @StatusFontFlags VarChar(500)
AS

UPDATE TaskListStatus SET
  StatusDescription = @Description,
  StatusFontFlags = @StatusFontFlags
WHERE ID = @StatusID;