Random Password Generator

declare @password varchar(8)
set @password=''
select @password=@password+char(n) from
(
	select top 8 number  as n from master..spt_values 
	where type='p' and number between 48 and 122
	order by newid()
) as t
select @password

Comments

# SSQA.net - SqlServer-QA.net said on November 20, 2007 7:39 AM:

This is one of the methods to generate 8 chracters password randomly (combination of alphabets,numbers

# Other SQL Server Blogs around the Web said on November 20, 2007 7:49 AM:

This is one of the methods to generate 8 chracters password randomly (combination of alphabets,numbers