tasklist_getcategorybyid.sql

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

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

CREATE PROCEDURE Tasklist_GetCategoryByID
	@CategoryID BigInt
AS

SELECT ID AS CategoryID, Description AS Description, IconUrl AS IconUrl
FROM TaskListCategories WHERE ID = @CategoryID;