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 sure that the first letter of each word is capitalized. Continue reading “T-SQL to Enforce Proper Case Capitalization”
Here is a super-simple example of using a T-SQL query to find records that have more than one table entry. Continue reading “T-SQL Simple Example of Finding Records with More than One Entry”
SQL Server 2000 is an old database platform now, but it is still fairly widely used. That’s why it’s good to know how to pass a list of parameters to a stored procedure on the SQL Server 2000 database platform. Likewise, the code is forwards compatible and will work with more modern versions of SQL Server such as 2008.