<div>
If you generated something based on the current full date time down to the millisecond, that is almost certain to be unique...<br />
<br />
If you need some help with code to to that, give us a shout<br />
<br />
Cheers<br />
<br />
Alex
</div>


If you generated something based on the current full date time down to the millisecond, that is almost certain to be unique...

If you need some help with code to to that, give us a shout

Cheers

Alex

<div>
That's the ticket. I was thinking of creating a second while loop but had no idea on the best way to go about it. Many thanks.<br />
<br />
Regards,
</div>


That's the ticket. I was thinking of creating a second while loop but had no idea on the best way to go about it. Many thanks.

Regards,

<div>
<div class="content wysiwyg-content">
I have found many examples of SQL random password generators but nothing that will check whether it is unique.<br />
<br />
I am generating a username/password for security on a public system. The username is an email and the initial password needs to be randomly generated and not equal to any existing password held on my user security table.<br />
<br />
I am pretty sure that some one must have a function already?<br />
<br />
Any help would be greatly appreciated. <br />
<br />
Regards,
</div>
</div>


I have found many examples of SQL random password generators but nothing that will check whether it is unique.

I am generating a username/password for security on a public system. The username is an email and the initial password needs to be randomly generated and not equal to any existing password held on my user security table.

I am pretty sure that some one must have a function already?

Any help would be greatly appreciated. 

Regards,

SQL random AND unique password generation?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.