kenambrose (10/30/2014)

---

very simple solution to all the nonsense.

MAKE ALL COLUMNS NOT NULLABLE.

If you can't figure out how to design a schema where that works for your business requirements, you...

One little nasty to be aware of is the use of NOT IN with nulls. This simplifed snippet shows the problem. If f2 in t2 contains any nulls, the...