If
Date2
is always five days after
Date1
, then you don't need to store
Date2
at all. Just use a computed column.
ALTER TABLE TableName
DROP COLUMN Date2;
ALTER TABLE TableName
ADD Date2 As (DateAdd(day, 5, Date1));
Specify Computed Columns in a Table - SQL Server | Microsoft Docs[
^]
As per
your previous question[
^], if you ever need
Date2
to be anything other than
Date1 + 5 days
, you cannot add a
CHECK
constraint to your table.