消息156,级别15,状态1,第3行关键字'check'附近有语法错误.altertablesellorderaddconstraintcksenddatecheck(senddate>orderdate)check(arrivaldate>senddate)go

Question

消息 156,级别 15,状态 1,第 3 行 关键字 'check' 附近有语法错误.
alter table sell_order
add constraint ck_send_date
check (send_date>order_date)
check(arrival_date>send_date)
go

Answer 1

alter table sell_order
add constraint ck_send_date
check(send_date>order_date or arrival_date>send_date)
go
应该没有你那种语法