Random Password Generator

 

This is one of the methods to generate 8 characters password randomly (combination of alphabets,numbers and special characters)



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



 
Published 20 November 2007 13:21 by Madhivanan
Filed under: ,

Comments

No Comments