Handling Nulls

Null is an unknown value. Null is Schrodinger's Cat's state before opening the box. There are ways to deal with null that are unlike anything else in the database, both in concept and in function. Equalities/Inequalities Nothing can equal or not equal Null. Not even another Null. It is an unknown value. Only something that is … Continue reading Handling Nulls

Null Parameters in WHERE Conditions

When building a procedure, I want to be able to pass a parameter or pass a NULL if I don't want to search by a parameter. Some people will tell you to accomplish this that you should write a dynamic SQL statement so you can add or remove parameters as needed. I avoid Dynamic SQL … Continue reading Null Parameters in WHERE Conditions