Technical Article

Alphanumeric and Special Character Validation

Inspired in the script submited by ramesh_kondaparthy , this is a set oriented solution for the same problem.Parameters: 1) @InputString varchar(25)Accepts the string, which we need to validate 2) @Type int = 0 validate the string for only alphanumeric charactersi.e Allows characters between [A-Z] ,[a-z] and [0-9] = 1 validate the string for alphanumeric and […]

You rated this post out of 5. Change rating

2006-08-22 (first published: )

4,015 reads

Blogs

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

Dealing with Changing Data Formats: Schema Drift in Azure Data Factory

By

(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in...

Adding Manual Relationships Between Tables in the TDM Subsetter

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

Read the latest Blogs

Forums

SSL Certificate Chain

By suchit.d@promantia.com

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI

By suchit.d@promantia.com

I’m encountering an SSL certificate chain issue when trying to connect to my SQL...

How Much Linux Do You Need?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Much Linux Do You...

Visit the forum

Question of the Day

Precision and Scale II

What is the precision, scale, and length for an int variable?

See possible answers