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

Record Length

Record Length of a Float data type


maximum length of Dimension Attribute

maximum length of Dimension Attribute


export fixed-length flat file

fixed length with line feed


Average Disk Queue Length 100 %

Average Disk Queue Length 100%


String Max Length

the max length of datatype varchar