SQL check with an if statement

Question

Quick question on SQL how can I make a check such as:

Alter Table Invoices WITH NOCHECK
ADD CHECK

Now this is the part where I want to add a check so that the column PaymentDate can be null if another column Payment Total is equal to 0 and also that PaymentDate is not null if Payment Total is greater than 0.

MySQL or SQL Server? MySQL (still, afaik) does not honour check constraints at all (although it happily parses them) — Joachim Isaksson
– Joachim Isaksson, Commented Aug 11, 2013 at 18:22
What's wrong the docs? What is your specific question? Look into conditionals, look into null checking, and alter table syntax. This is assuming you mean MySQL and not SQL Server. Read the tag popouts before adding them. — BLaZuRE
– BLaZuRE, Commented Aug 11, 2013 at 18:26

jazzytomato · Accepted Answer · 2013-08-11 18:24:58Z

5

Here is a way to do it :

Alter Table Invoices WITH NOCHECK
ADD CHECK (   (PaymentTotal > 0 AND PaymentDate IS NOT NULL) 
           OR (PaymentTotal = 0 ) )

answered Aug 11, 2013 at 18:24

jazzytomato

7,2593 gold badges33 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daniel Erb Over a year ago

Thanks, as usual I was trying to way over complicate this when it did not need to be...

Collectives™ on Stack Overflow

SQL check with an if statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related