Fix WHERE clause AND/OR/NOT confusion with truth tables

,

The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it like plain-Jane algebra. Here I show you how to figure out exactly what a query is doing, using truth tables!

The post Fix WHERE clause AND/OR/NOT confusion with truth tables appeared first on The MidnightDBA Star-Times.

Rate

Share

Share

Rate