aidmondo Starting Member
Ghana 23 Posts
vijays3 Constraint Violating Yak Guru
India 311 Posts
DO below one Create table Date ( StartDate datetime not null , EndDate datetime not null ) alter table Date add check (StartDate < EndDate)
sunitabeck Flowing Fount of Yak Knowledge
5152 Posts
quote:Originally posted by aidmondoCreate table Date( StartDate datetime not null, EndDate datetime not null)How do i use the CHECK Constraint to make the StartDate < EndDateaidmondo
ALTER TABLE [Date] ADD CONSTRAINT chkDates CHECK (StartDate < EndDate );
visakh16 Very Important crosS Applying yaK Herder
India 47099 Posts
quote:Originally posted by vijays3 DO below one Create table Date ( StartDate datetime not null , EndDate datetime not null ) alter table Date add check (StartDate < EndDate)Vijay is here to learn something from you guys.
Check Constraint
Posted - 05/14/2012 : 06:47:21
