Generate Random Alphanumeric String

By Additional Articles, 2005/01/24

Here's a short script to generate a random alphanumeric string based on newid(). The procedure takes in length (@len) which determines the key length. Length must be between 8 and 32. Result is returned in an output parameter. A test script is supplied.

Total article views: 1208 | Views in the last 30 days: 5

FORUM

Record Length

Record Length of a Float data type

FORUM

maximum length of Dimension Attribute

FORUM

export fixed-length flat file

fixed length with line feed

FORUM

Average Disk Queue Length 100 %

Average Disk Queue Length 100%

FORUM

String Max Length

the max length of datatype varchar

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Generate Random Alphanumeric String

Record Length

maximum length of Dimension Attribute

export fixed-length flat file

Average Disk Queue Length 100 %

String Max Length

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: