April 13, 2011 at 3:55 am
Hi I am trying to do a Login stored procedure with using email address and password
Would it be like this:
create procedure [dbo].[Get_Customer_Login]
(
@password nvarchar(255)
@email nvarchar(255)
)
as
select * from tblCustomers$
where Password = @password
and emailaddr = @emailaddr
April 13, 2011 at 4:12 am
Hi,
will the stored procedure accessed by a application and what do you want to do with this login?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
April 13, 2011 at 5:46 am
Have you tried it? Is it not working or are you getting an error?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2011 at 4:44 pm
I truly hope you're not sending the password as plain text and compare it to another plain text value....
What concept do you use to store the password?
Welcome, dear neighbor! (distance: 13km) 😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply