sp_CheckPassword

最新推荐文章于 2023-07-07 19:51:39 发布

阅读量463

点赞数

文章标签： output

本文介绍了一个SQL存储过程sp_CheckPassword，用于验证用户的账号名、密码和角色名称是否匹配。通过查询视图V_CheckPassword来检查用户是否存在及密码是否正确。

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