Check Constraint for Null and …
10-Nov-1010 Leave a comment
ALTER TABLE [Production].[TimeSheet] WITH CHECK ADD CONSTRAINT [CK_TimeSheet_TimeEndLaterThanStart] CHECK (([TimeEnd] IS NULL) OR [TimeEnd]>=[TimeStart])
IT and business subjects
10-Nov-1010 Leave a comment
ALTER TABLE [Production].[TimeSheet] WITH CHECK ADD CONSTRAINT [CK_TimeSheet_TimeEndLaterThanStart] CHECK (([TimeEnd] IS NULL) OR [TimeEnd]>=[TimeStart])
Filed under SQL Server