Category: SQL

SQL Server IIF: Syntactic Sugar that Doesn’t Rot Your Brain

It wasn’t until recently that I discovered a feature that I’ve missed since SQL Server 2012.  One of my recent projects involved converting a lot of old Visual FoxPro code.  That’s not quite as much fun as it sounds, as it turns out.

CROSS APPLY Keeps Me Sane

There hasn’t been a great deal of routine from year to year throughout my career.  Microsoft has moved from VB6 to progressively more advanced incarnations of the .NET framework and versions of SQL Server have added Intellisense and more features than I

Top