Advanced Search

Return to Snippet

Revision: 10955
at January 19, 2009 10:27 by mynameisharry
Initial Code 
Select Top 1 word + cast(cast((RAND() * 9)+1 as int) as varchar(3)) + cast(cast((RAND() * 9)+1 as int) as varchar(2)) As Password From dictionary order by newid()
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Create a random password using a Dictionary database table.
Selects a random word, and then appends two random numbers to the end,  creating passwords in the form of: foozling98 or laicism11

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Creating a random password using dictionary table

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL