Generate Simple alpha numeric random password in sql server

Generate Simple alpha numeric random password in sql server

In sql server we can generate a simple alpha numeric random password by a single statement.

SELECT SUBSTRING(CONVERT(varchar(255), NEWID()), 0, 7)