Tag Archive for ‘technical’

Case statements in T-SQL

If you’re used to working with If-Else statements in 3rd generation languages such as Java and C++ then you will find that Case statements can be useful when constructing complex queries in T-SQL. Very handy when there are a lot of requirements about how and where data should be extracted from. An example: CustomerContactAddress contains all address records for your existing customers. In this scenario, you want to: Select all […]

Continue Reading →