use tempdb go if object_id('tempdb..test') is not null drop table dbo.testcreate table dbo.test(id int not null ,begin_date datetime ,end_date datetime )ALTER TABLE dbo.test ADD CONSTRAINT CK_test_date CHECK (begin_date<end_date)--test insert into dbo.test select 1,getdate(),getdate()-1
go
if object_id('tempdb..test') is not null
drop table dbo.testcreate table dbo.test(id int not null
,begin_date datetime
,end_date datetime )ALTER TABLE dbo.test ADD CONSTRAINT CK_test_date
CHECK (begin_date<end_date)--test
insert into dbo.test
select 1,getdate(),getdate()-1