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

2004-07-06 (first published: )

2,477 reads

Blogs

Daily Coping 3 Oct 2022

By

Today’s coping tip is to write down three things you appreciate about yourself. I...

Scary Scalar Functions - Part Four: Your Environment

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Read the latest Blogs

Forums

encrypt the database in azure

By juliava

How can we encrypt the database in Azure. Research story.   Thank you

Shrink database issue

By don075

In my database, I have few temp tables that total up to 50GB in...

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.

By serverdba

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers