Register now or log in to join your professional community.
We can use SP
ALTERPROCEDURE[dbo].[spCheckMemberLogin](@username VARCHAR(100)=default,@hash VARCHAR(100)=default)ASBEGINSET NOCOUNT ON;SELECT3as result ,*FROM web_user WHERE(statusId =1)AND(useremail =@username)AND(hash =@hash)END