Home Forums SQL Server 2005 SQL Server 2005 Strategies Check Constraint RE: Check Constraint
CanuckBuck
Hall of Fame
Points: 3915
More actions
February 11, 2009 at 12:05 pm
#942416
I've managed to solve my own problem. It was easier than I thought, I've just never done anything like that before.
It amounts to;
CONTSTRAINT One_or_the_Other CHECK ((AAA IS NULL AND BBB IS NOT NULL) OR (AAA IS NOT NULL AND BBB IS NULL))