tasklist_setnumberofitemstodisplayperpage.sql

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

-- =============================================
-- TaskList_SetNumberOfItemsToDisplayPerPage
-- =============================================
-- Retrieves the number of task list items to display per page on the task list 
-- for the user specified
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_SetNumberOfItemsToDisplayPerPage' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_SetNumberOfItemsToDisplayPerPage
GO

CREATE PROCEDURE TaskList_SetNumberOfItemsToDisplayPerPage
	@Username VarChar(20),
  @PasswordHash VarChar(50),
  @NumberOfItems VarChar(20)
AS
DECLARE @CurrentUserID BigInt
SET @CurrentUserID = NULL

SELECT @CurrentUserID = ID FROM TaskListUsers WHERE Username = @Username AND PasswordHash = @PasswordHash
IF (@CurrentUserID IS NULL) Return 1;

UPDATE TaskListUsers SET ItemsToDisplay = @NumberOfItems WHERE ID = @CurrentUserID;