Justin Cooney
Web Development Tips and Examples
Author: Justin Cooney
-
In this article I will review three easy methods that can be used to replace extra spaces between words in a string. Note that if you want to remove extra spaces from the start and end of your string you will still need to encapsulate the output of the routines within the standard LTrim /…
-
The OUTPUT clause is a useful part of your T-SQL arsenal that has been added as of SQL Server 2005. You can use the OUTPUT clause in the same vein as @@IDENTITY, IDENT_CURRENT, or SCOPE_IDENTITY(), or even extend it to be a historical logging mechanism. Unlike @@IDENTITY, or SCOPE_IDENTITY(), you need to populate a table…
-
I’ve always been curious about the popularity of the most commonly used programming languages, but haven’t been able to find a reliable (non-biased) source. I decided to take matters into my own hands and use the Google trends tool to see the frequency with which five of the most commonly used server-side programming languages have…