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

2006-08-22 (first published: )

1,410 reads

Blogs

What goes around comes around : T-SQL Tuesday #129

By

I almost died. I’m sure a lot of you already know this but just...

My T-SQL Tuesday #129 Time Capsule

By

This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...

Azure Database Administrator

By

Recently I found out that I passed the BETA exam for Azure Database Administrator...

Read the latest Blogs

Forums

Time out expired on the application side

By zouzou

Hi   I have an application that is timing out i run the query...

Sum function in CTE is not calculating the right balance

By Ysa

I have table with all charges and payment the charges are 'c'  and payments...

Attacks on Unsecured Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Attacks on Unsecured Databases

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers