Probably this question occurs to me, since to my lack of experience, but I tried to figure out how to do it, and I can't find a solution...
Imagine my table T:
CREATE TABLE T (
, B INT
, C BIT
I need to constraint (A,B,C) in such a way that I can have multiple (A,B,0) but at most, only 1 (A,B,1).
Is there a way for me to cerate a relational constraint or should I explicit code it in my SPs?
Thanks in advance