tasklist_loguserin.sql

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

-- =============================================
-- TaskList_LogUserIn
-- =============================================
-- Returns a user id if this is a valid user
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_LogUserIn' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_LogUserIn
GO

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

	SELECT @CurrentUserID=ID
	FROM TaskListUsers 
	WHERE Username = @Username AND PasswordHash = @PasswordHash;

	IF (@CurrentUserID IS NULL)
		RETURN 1; --Invalid user
	ELSE
		SELECT @CurrentUserID