watherton
asked on
Prevent duplicate entries
Hi experts,
I have a sp that inserts (registers) user, how can I stop getting multiple entries of the same user, for example, an operator enters the following details:
First Name: Wayne
MiddleName: A
LastName : Atherton
etc......
the sp returns an out put value for the new user id, so how do I prevent another user being entered with exactly the same details, currently after i insert a new users a auto number is created to represent the user.
cheers
Wayne
I have a sp that inserts (registers) user, how can I stop getting multiple entries of the same user, for example, an operator enters the following details:
First Name: Wayne
MiddleName: A
LastName : Atherton
etc......
the sp returns an out put value for the new user id, so how do I prevent another user being entered with exactly the same details, currently after i insert a new users a auto number is created to represent the user.
cheers
Wayne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER