Canadian Postal Code validator
This is a slight improvement on the script posted the other day. Uses PATINDEX for pattern match, and checks for forbidden characters D, F, I, O, Q, U.
2007-08-14 (first published: 2007-01-15)
113 reads
Blogs
When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.
When studying Azure one of the things you’ll be asked to learn is the...
SQL Server Statistics Health Reminder
I’ve written about statistics in SQL Server a few times now. Through conversations I...
Running SQL Server containers as non-root
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
transaction delay when replica unavailable - what effect?
I'm using AlwaysOn synchronous replica. User issues an update on primary via SSMS. In...
need to calculate Group by date
hi, i'm creating a view and need some help. i have the column "valorTotal"...
Ask SSC