SQL 2005 user defined function to convert a string to proper case (title case).Flexible handling of delimiters and apostrophes to cater for words like "hasn't" and also names like "O'Reilly" and "d'Angelo".Mac and Mc surnames are handled generically, with some rules and exceptions which may need to be extended. Since McIntyre and Mcintyre are both […]
2007-03-14 (first published: 2007-02-14)
932 reads
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DBAs are being asked to know everything for 6 figures which cap out for...
Comments posted to this topic are about the item Common Table Expression Misunderstandings
I have a DAG between On prem and Azure. We have a maintenance window...
Ask SSC