Technical Article

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: […]

You rated this post out of 5. Change rating

2004-07-06 (first published: )

2,606 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

Validating Password Expiration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Validating Password Expiration

Extracting multiple fields from one column

By JeremyU

    Hello, I have a situation. I am trying to show each  distinct...

Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances

By Parthprajapati

Comments posted to this topic are about the item Unlock the Power of Google...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers