You are here: Home Page 
Tutorials MySQL & C, C++ Randomly generate password in SQL Server 2008 - tutorial advance
Tutorials MySQL & C, C++ Randomly generate password in SQL Server 2008 - tutorial advance
Randomly generate password in SQL Server 2008
destination source:https://www.programming-techniques.com/2012/06/randomly-generate-password-in-sql-server-2008.html
There are lots of ways of generating random strings in SQL Server. But instead of spending much time on finding solution to random password generation, here is an easy way to do that.
SELECT SUBSTRING(convert(varchar(50),NEWID()),0,8) as password
This generates 8 characters long password which is a random string.
Some results:-
673CB61
6BD26C7
7F5F1EB
Related Article
destination source:https://www.programming-techniques.com/2012/06/randomly-generate-password-in-sql-server-2008.html
