Showing posts with label Random varchar Password generation. Show all posts
Showing posts with label Random varchar Password generation. Show all posts

Saturday, August 8, 2009

Random varchar Password generation in My-Sql and Ms-Sql

The simplest way to generate random passwords


Ms-Sql

SELECT LEFT(NEWID(),8)


My-Sql


SELECT Left(MD5(RAND()),8) AS password