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

Question

insert into RegisterTable (Name,email,HashPassword,ActivationCode,verify)
values ('qwert','[e-mail]',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