Other News

Community

The Case for SQL CASE

(Sam Lennon) Did you know that the SQL CASE construct can be used in SQL SELECT and UPDATE statements and in WHERE, GROUP BY, and ORDER BY clauses? This tip explains SQL CASE through examples that you can run and experiment with. It also gives an overview of SQL CASE syntax, though it does not attem

Editorials

Wrap Up Database Naming Conventions

Wrap Up Database Naming Conventions I thought I would close the thoughts on Database naming conventions with a few things I find helpful, and then include thoughts submitted by others. These are a few things I like to use in my naming conventions…these are ideas that I don’t simply follow blindly. I don’t mind long names for tables, views, columns, […]