Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Generate Random Alphanumeric String

By Additional Articles,

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: 1246 | Views in the last 30 days: 4
 
Related Articles
FORUM

Record Length

Record Length of a Float data type

FORUM

maximum length of Dimension Attribute

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

 
Contribute