Gaurav Raj

Gaurav Raj

  • 1.4k
  • 475
  • 33.1k

I am Try to login with store procedure ......see my code

Mar 30 2019 5:25 AM
insert into RegisterTable (Name,email,HashPassword,ActivationCode,verify)
values ('qwert','qwert@yahoo.com',HASHBYTES('SHA2_256','12345'),124,0)
 
 
 
CREATE PROCEDURE [dbo].[LoginProcedure]
    @Email varchar(50),
    @HashPass nchar(32)
AS
    SELECT * from RegisterTable
    where email=@Email and HashPassword =HASHBYTES('SHA_256',@HashPass)
RETURN 0

Answers (5)