【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“TaskList_GetTaskListProperties.sql”一文,供大家参考学习!
-- =============================================
-- TaskList_GetTaskListProperties
-- =============================================
-- Retrieves statistics about a given task list
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'TaskList_GetTaskListProperties'
AND type = 'P')
DROP PROCEDURE TaskList_GetTaskListProperties
GO
CREATE PROCEDURE TaskList_GetTaskListProperties
@Username VarChar(20),
@PasswordHash VarChar(50),
@TaskListID BigInt
AS
DECLARE @CurrentUserID BigInt
SET @CurrentUserID = NULL
--Make sure that this is a valid user, and that this user has manager priviledges
SELECT @CurrentUserID=ID
FROM TaskListUsers
WHERE Username = @Username AND Pass
wordHash = @PasswordHash AND IsManager = 1;
IF (@CurrentUserID IS NULL) RETURN 1; --Invalid user
SELECT Count(ID) AS TaskListItems,
Max(ModifiedDate) AS LastModified,
Max(CreatedDate) AS LastCreated
FROM TaskListItems WHERE TaskListID = @TaskListID