Organizing SQL Queries

How can I effectively organize my SQL query code to further reuse? In their everyday life, many people use SQL to construct queries that they are going to reuse at some point. But how do these [...]

SQL pattern matching

Pattern matching over strings in SQL is a frequent need, much more frequent that some may think. Queries aren’t just for compiling demanding aggregate calculations, advanced joins and table [...]

HowTo: SQL type casting

While in an ideal world each column in a database table has a suitably chosen data type, in this non-ideal place we live in, having stored dates in a wrong format, is a problem that the majority [...]

12