How do I build a constraint that depends on another column - SQL 2000

Question

question

khalil123456 asked Dec 4, '16

How do I build a constraint that depends on another column - SQL 2000

I want to make a constraint (if one field is not null, the end user must put 3 or 5 or 10 in another field) and the two fields are in the same table. To put it another way, if the end user puts any value in field A, I also want them to put specified values in field B? Can any one help me please? Thanks for help

sql-server-2000 constraint analysis

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2016-12-05T09:27:43Z

Magnus Ahlkvist answered Dec 5, '16

ALTER TABLE ADD CONSTRAINT CK_IF_A_THEN_B CHECK ((A IS NULL) OR (B IN (3,5,10)));

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

GPO commented · Dec 07, 2016 at 04:22 AM

@khalil123456 If Magnus's response answer's your question, please mark it as your selected answer for the benefit of other users.

0 ·

question