这个是我错误的方法
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),
)
这是题目要求
这个是我错误的方法
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),
)