I've been trying to do the following but I got errors: 1) <pre>ALTER TABLE Workshops ADD CONSTRAINT CK_Workshops_EndDate5daysAfterStartDate CHECK (EndDate = StartDate + 5);
ALTER TABLE Workshops ADD CONSTRAINT DF_EndDate_5daysAfterStartDate DEFAULT DATEADD(day, 5, StartDate )
<pre>ALTER TABLE TableName ADD CONSTRAINT CK_TableName_Date2Is5DaysAfterSTartDate CHECK (Date2= DATEADD(day, 5, StartDate));
The ALTER TABLE statement conflicted with the CHECK constraint "CK_TableName_Date2Is5DaysAfterSTartDate".
ALTER TABLE TableName ADD CONSTRAINT CK_TableName_Date2Is5DaysAfterSTartDate CHECK (Date2= DATEADD(day, 5, StartDate));
CHECK
DEFAULT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)