Generate Password using Stored Procedure in SQL Server

Create Procedure[dbo].[uspGeneratePassword]

@Passwordvarchar(50)OUTPUT

AS

BEGIN

DECLARE@PasswordLengthint;

DECLARE@Countint;

DECLARE@Rndint;

SET@PasswordLength= 10;

SET@Password='';

SET@Count= 1;

WHILE@Count<=@PasswordLength

BEGIN

SET@Rnd=Convert(int,(1 +RAND()*(9-1)));

SELECT@Password=@Password+

CASE

WHEN@Rnd>=1 AND@Rnd<=3 THEN

CHAR(Convert(int,(97 +RAND()*(122-97))))

WHEN@Rnd>=4 AND@Rnd<=6 THEN

CHAR(Convert(int,(65 +RAND()*(90-65))))

WHEN@Rnd= 7 THEN

CHAR(Convert(int,(48 +RAND()*(57-48))))

ELSE

CHAR(Convert(int,(35 +RAND()*(38-35))))

END

SET@Count=@Count+ 1;

END

END;

DECLARE@PassNVARCHAR(50)

exec [dbo].[uspGeneratePassword]@Password=@PassOutput

SELECT@Pass