UDF Random Password Generator

/*


You can not use the RAND function directly from a User Defined Function. 
So the UDF I wrote "fn_RandomPassword" uses the view "view_RandomPassword8" 
to get the random charaters.

Having the random password generator is useful if you need to insert 
a large number of users into a table with random passwords assigned.

For example ..

INSERT INTO User_Table
( UserLogin, UserPassword )
SELECT UserLogin, dbo.fn_RandomPassword() as UserPassword
FROM Import_Users_Table

.. all the users from the import table could be inserted 
with random passwords very easily.

*/


-------------------------------------------------------------------
-- Get a random 8 charater password that always starts with a letter
-- By: Robert Rinchuse Jr
--
-- Select RandomPassword From view_RandomPassword8
-------------------------------------------------------------------
CREATE VIEW view_RandomPassword8 AS 
-- select * from view_RandomPassword8
SELECT
	CASE ROUND(1 + (RAND() * (1)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	ELSE CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	END 
	+
	CASE ROUND(1 + (RAND() * (2)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	WHEN 2 THEN CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	ELSE CHAR(ROUND(48 + (RAND() * (9)),0)) -- get random number
	END
	+
	CASE ROUND(1 + (RAND() * (2)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	WHEN 2 THEN CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	ELSE CHAR(ROUND(48 + (RAND() * (9)),0)) -- get random number
	END
	+
	CASE ROUND(1 + (RAND() * (2)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	WHEN 2 THEN CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	ELSE CHAR(ROUND(48 + (RAND() * (9)),0)) -- get random number
	END
	+
	CASE ROUND(1 + (RAND() * (2)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	WHEN 2 THEN CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	ELSE CHAR(ROUND(48 + (RAND() * (9)),0)) -- get random number
	END
	+
	CASE ROUND(1 + (RAND() * (2)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	WHEN 2 THEN CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	ELSE CHAR(ROUND(48 + (RAND() * (9)),0)) -- get random number
	END
	+
	CASE ROUND(1 + (RAND() * (2)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	WHEN 2 THEN CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	ELSE CHAR(ROUND(48 + (RAND() * (9)),0)) -- get random number
	END
	+
	CASE ROUND(1 + (RAND() * (2)),0)
	WHEN 1 THEN CHAR(ROUND(97 + (RAND() * (25)),0)) -- get random lower case
	WHEN 2 THEN CHAR(ROUND(65 + (RAND() * (25)),0)) -- get random upper case
	ELSE CHAR(ROUND(48 + (RAND() * (9)),0)) -- get random number
	END

	as RandomPassword

GO


-------------------------------------------------------------------
-- Get a random 8 charater password that always starts with a letter
-- By: Robert Rinchuse Jr
--
-- PRINT dbo.fn_RandomPassword()
-------------------------------------------------------------------
CREATE FUNCTION dbo.fn_RandomPassword()
RETURNS varchar(8)
AS
BEGIN
	DECLARE @RandomPassword varchar(8)

	SELECT @RandomPassword = RandomPassword
	FROM view_RandomPassword8

	RETURN @RandomPassword

END
GO