CHECK for two columns

Question

I have a problem with my code. As you can see i Try to have a sort of CHECK constraint using two columns in the same table but seems does not work. My need is to accept value in EffectiveEndDate only if they are > that EffectiveStartDate.

Any idea how to solve it? thanks for your support! :-)

CREATE TABLE dbo.Test 
(   
EffectiveStartDate  dateTime2(2)        NOT NULL,
EffectiveEndDate    dateTime2(2)        NOT NULL
    CONSTRAINT CK_CmsSponsoredContents_EffectiveEndDate CHECK (EffectiveEndDate > EffectiveStartDate),
);

The constraint appears to be correct to me. What isn't working? Are you able to insert end dates that are before the start dates? — Oded, Aug 09 '10 at 08:13
possible duplicate of [CHECK CONSTRAINT on multiple columns](http://stackoverflow.com/questions/3438066/check-constraint-on-multiple-columns) — Oded, Aug 09 '10 at 08:16

score 4 · Accepted Answer · answered Aug 09 '10 at 08:16

You've got a comma in the wrong spot:

CREATE TABLE dbo.Test(  
  EffectiveStartDate dateTime2(2) NOT NULL,
  EffectiveEndDate   dateTime2(2) NOT NULL,  -- added missing comma
  CONSTRAINT CK_CmsSponsoredContents_EffectiveEndDate CHECK (EffectiveEndDate>EffectiveStartDate)
)

Removed a comma at the end of the check constraint declaration.

CHECK for two columns

1 Answers1