tasklist_updatecategory.sql

该项目管理系统可对项目的过程进行管理和控制

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

CREATE PROCEDURE TaskList_UpdateCategory
	@CategoryID BigInt,
  @Description VarChar(25),
  @IconUrl VarChar(500)
AS

UPDATE TaskListCategories SET
  Description = @Description,
  IconUrl = @IconUrl
WHERE ID = @CategoryID;