drop table test
go
create table test ( a int not null CONSTRAINT check_a check ( a>0 ), b int CONSTRAINT check_b check (b>1),c char(1) CONSTRAINT check_c check (c in ('Y', 'N') ) )
go
create table test ( a int not null CONSTRAINT check_a check ( a>0 ), b int CONSTRAINT check_b check (b>1),c char(1) CONSTRAINT check_c check (c in ('Y', 'N') ) )
ADD CONSTRAINT CHECK_CRUISE CHECK (duration>0 AND price>0 AND (airfare='Y' or airfare='N'))
ADD CONSTRAINT CHECK_CRUISE CHECK (duration>0 AND price>0 AND airfare IN ('Y','N'))