Generate Random Alphanumeric Strings

This script will generate and populate a table variable with a stipulated number of unique 8 randomly generated character alphanumeric values. This can be useful in situations where one has to allocate passwords or unique id to users. It accepts one input parameter "@HowMany int" representing the number of these alphanumeric values to generate; default=500.Usage: […]

2004-07-06 (first published: )

873 reads

Blogs

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

SQL Server 2019 on Docker no longer runs as root by default

By

In my home lab I have an Ubuntu virtual machine that runs both SQL...

SQL Server 2019 – Compatibility Level in Azure

By

I am not sure when this became available but for Azure SQL Database 150...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

SSIS catalog deployment from source server to target - powershell

By iKvfpMWsaoC1Gy8

I am looking for a good solution for automating the deployment of SSIS packages...

XML Data singleton value not fixed????

By jbalbo

Hi Hope to explain this correctly I have some XML data that can vary...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers