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