Archive for category SQL
SQL CASE statements and Data Types
Synopsis: All return values from a T-SQL CASE statement must be of the same Data Type. …He thought the request was simple. “Before you leave [for the weekend], can you make one tiny change…it shouldn’t take more than a minute?” Or, so I heard a Friday past. “Can we sort the results dynamically?”. I wanted […]
Don’t add hacks, make features!
Posted by dda in General Technology, SQL on December 10, 2011
Synopsis: Use SQL and a bit (sorry) of bit comparison to create a “Feature Framework” Is there a good way to add what amounts to nothing more than a HACK to your application? Probably not, but there are ways to mitigate the damage. I was recently given the task of modifying a well-designed client-server application […]