April 2013
-
T-SQL – Using the OUTPUT Clause to Get Identity Keys and Log Historical Data
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…
-
Reviewing the Popularity of 5 Commonly Used Server-Side Programming Languages
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…