Justin Cooney
Web Development Tips and Examples
Category: SQL Tips
-
This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make…
-
If you are looking for either null or blank values for a date field in SQL Server Reporting Services (SSRS) you will find that checking for IsNothing only identifies the Null values, but ignores the blank values. So what’s the quickest and easiest way to do this?
-
Here is a super-simple example of using a T-SQL query to find records that have more than one table entry.
Justin Cooney 