My blog has moved!

You will be automatically redirected to the new address. If that does not occur, visit
and update your bookmarks.

Thursday, June 28, 2012

Randomly generate password in SQL Server 2008

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 charcters long  password which is a random string.

Some results:-




1 comment :