Create stored procedure for users registration. Procedure accepts two parameters: username and password and introduces these two values into table entitled Users. Table users has three columns: ID, username and password. When activating procedure it is first to check if the user with that username already exists in the table. If exists, the entry does not execute and the procedure returns an error message (number -1). If the user does not exist the entry introduces to database and the procedure returns success message (zero 0).
I think the problem is that adelle is taking a test she didn't study for - hence the urgency.
I don't think there is anyone that could come up such clear and concise requirements that couldn't do the coding themselves. That is why I'm going with test question.
stored procedure problem_urgent!!!
Posted - 11/09/2012 : 16:16:57
