SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE sp_CheckPassword @accountName VARCHAR(12), @passwordText VARCHAR(20), @roleName NCHAR(4), @checkResult INT OUTPUT --0:都正确 --1:用户存在,但密码不正确 --2:用户不存在 AS BEGIN IF EXISTS( SELECT * FROM V_CheckPassword WHERE AccountName = @accountName ) BEGIN IF EXISTS( SELECT * FROM V_CheckPassword WHERE AccountName = @accountName AND PasswordText = @passwordText AND RoleName = @roleName ) BEGIN SET @checkResult = 0 RETURN 0 END ELSE BEGIN SET @checkResult = 1 RETURN 1 END END ELSE BEGIN SET @checkResult = 2 RETURN 2 END END GO