读书人

建表失解决方案

发布时间: 2012-01-29 21:39:32 作者: rapoo

建表失
行下面的SQL句建表失,各位如何解?!!

CREATE table enrolls
(sno numeric(6,0) not null,
cno char(4) not null,
grade int
primary key (sno,cno)
foreign key (sno) references students(sno)
foreign key (cno) references courses(cno)
check((grade is null)or(grade between 0 and 100)))

提示:More than one column FOREIGN KEY constraint specified for column 'grade ', table 'enrolls '.


[解决办法]
CREATE table enrolls
(sno numeric(6,0) not null,
cno char(4) not null,
grade int ,
primary key (sno,cno),
foreign key (sno) references students(sno),
foreign key (cno) references courses(cno),
check((grade is null)or(grade between 0 and 100)))
[解决办法]
...豆号
[解决办法]
‘,’逗号,不加的话,就把后面的约束全当成是grade字段的了,自然就more than...了

读书人网 >SQL Server

热点推荐