How to make sure that the start date is not later than the finish date?

Question

SQL Server

How to put a limit between two dates

Answer 1

CREATE TABLE [dbo].[StartFinish](
  [DateStart] [datetime] NULL,
  [DateFinish] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StartFinish] WITH CHECK 
  ADD CONSTRAINT [CK_StartFinish] CHECK ((datediff(day,[DateStart],[DateFinish])>(0)))
GO
ALTER TABLE [dbo].[StartFinish] CHECK CONSTRAINT [CK_StartFinish]
GO

Guide .