computer24hr (5/7/2014)
Password, it should be unique to each user name.The password is stored as nvarchar(10) it's text.
I thought the SP, what do you think?
Relatively low amount of changes but I need to allow this user, I have no amount of users so you can ignore the volume table or the number of users that is under construction right now.
This is straight forward BUT 10 character password:ermm: does not sound good! Of course this is your responsibility and your decision.
A stored procedure is perfect, now all you need to do is to provide a table structure and some sample data.
I strongly recommend and second Sean's comment, do not store un-encrypted passwords. My preference is to use a seeded hash, as the hashing process is quick but non reversible.
😎