Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adelle
Starting Member
1 Post |
 Posted - 2012-11-09 : 16:16:57
|
| 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). |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-09 : 17:38:10
|
| And what is the problem?-Chad |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-11-09 : 18:09:27
|
quote:
Originally posted by chadmat
And what is the problem?-Chad
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.Be One with the OptimizerTG |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
stored procedure problem_urgent!!!
Tara Kizer