Constraint where both columns cannot be null, but one can
ALTER TABLE TableA ADD CONSTRAINT CK_BothDepartsNotNull
CHECK (departA IS NOT NULL OR departB IS NOT NULL)
ALTER TABLE TableA ADD CONSTRAINT CK_BothDepartsNotNull
CHECK (departA IS NOT NULL OR departB IS NOT NULL)