This table contains 1lack records.
here user passwords contain alpha numeric.
we like to change all old users passwords
and new users as 4 digit numeric password.
So,I need a stord procedure by check the old passwords when
they login and convert that one into numeric.
details of stored procedure
outputparameter : password
if the password not existed(new users) for a particuler user, new random 4 digit password
will be returned.
if the password existed and in the form of alpha-numeric, new random 4 digit
password will be returned.
if 4 digit password existed for that user, initial password will be returned.