How can I write a stored procedure with SQL 2000 Server to check an e-mail and password entered by the user, and if both exist select the Id field ?
Table Users:
UserId
First_name
Surname
Age
E-mail
Password
If it is possible I would like to know how can I write the error messages in three cases: If E-mail doesn't exist, if password doesnt exist and if both doesnt exist. And I would like that those messages would be able to appear on the website application.
ThanksMay check Planet SC (http://planet-source-code.com) for any CE.|||Ok thank you
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment