检查用于验证电子邮件和存储的存储过程密码 [英] check stored procedure for verifying email & password

问题描述

  CREATE   PROCEDURE  [dbo]。[Proc_Verify_Password] 
  @ username   VARCHAR （ 20 ） ，
  @ password   varchar （ 20 ）
  AS  
  BEGIN  
 
 < span class =code-keyword> SET   NOCOUNT   ON  
 
  IF   EXISTS （ SELECT  * < span class =code-keyword> FROM  Authentication_Detail  WHERE  UserName =  @ username   AND  password =  @ password ）
  SELECT  '  1'  AS  UserExists 
  ELSE  
  SELECT  '  0'  AS  UserExists 
 
  END  

在这里，存储过程不适用于正确的用户名和密码..请给我一个解决方案..

解决方案

我测试了它并且工作正常

 CREATE PROCEDURE [dbo]。[Proc_Verify_Password] 
 @username VARCHAR（20），
 @password varchar（20） 
 AS 
 BEGIN 
 
 SET NOCOUNT ON 
 
 SELECT count（*）FROM Authentication_Detail 
 WHERE RTRIM（LTRIM（[UserName]）） = RTRIM（LTRIM（@username））
 AND RTRIM（LTRIM（[密码]））= R TRIM（LTRIM（@password））
 
 END 

你如何执行Sql命令。执行非查询或执行读者？

CREATE PROCEDURE [dbo].[Proc_Verify_Password]
    @username VARCHAR(20),
    @password varchar(20)
AS
BEGIN

SET NOCOUNT ON

IF EXISTS(SELECT * FROM Authentication_Detail WHERE UserName = @username AND password = @password)
    SELECT '1' AS UserExists
ELSE
    SELECT '0' AS UserExists

END

Here, stored procedure didn't work for correct username and password.. please give me a solution for this..

解决方案

I have tested it and works fine

CREATE PROCEDURE [dbo].[Proc_Verify_Password]
    @username VARCHAR(20),
    @password varchar(20)
AS
BEGIN
 
 SET NOCOUNT ON
 
SELECT  count(*) FROM Authentication_Detail 
WHERE RTRIM(LTRIM([UserName])) = RTRIM(LTRIM(@username)) 
AND RTRIM(LTRIM([Password])) = RTRIM(LTRIM(@password))

END

How are u executing the Sql command.As execute nonquery or execute reader?

这篇关于检查用于验证电子邮件和存储的存储过程密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！