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','[email protected]',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