Hi Friends!
I was searching for generating random character string for password in SQL Server and goggled a lot.
I have found various stored procedures and functions to generate random character password (it was really big procedures/functions !!) So I have given a thought and an idea strike on my mind and then I have found following, the most simplest way to generate random character string of password.
SELECT
LEFT(UPPER(NEWID()), 2) +
LEFT(LOWER(NEWID()), 2) +
LEFT(UPPER(NEWID()), 2) +
LEFT(LOWER(NEWID()), 2)
The above is very basic form to generate random character string for password. you can customize this according to your requirement (like variable password length and etc.)
Happy Programming :)
