sql server建立book表，约束条件有一条为订货日期小于交货日期，怎么建立表？

这个是我错误的方法

create table Book
(csid char(10),
cmid char(12),
count int check(count >0),
bookdate datetime ,check( takedate-bookdate>0)
takedate datetime,
primary key (csid,cmid),
)

这是题目要求

mssqlserver用下面的代码，有帮助麻烦点个采纳【本回答右上角】，谢谢~~有其他问题可以继续交流~

create table Book
(csid char(10),
cmid char(12),
count int, check(count >0),
bookdate datetime, check( takedate>bookdate),
takedate datetime,
primary key (csid,cmid),
)
 

create table Book
(csid char(10),
cmid char(12),
count int check(count >0),
bookdate datetime check (datediff(second, bookdate,takedate)<0)),
takedate datetime,
primary key (csid,cmid)
)