我写的报错了
--创建学生成绩表
create table stuMarks
(
--考号
ExamNo char(7) not null
constraint PK_ExamNo primary key(ExamNo),
--学号
stuNo nvarchar(20) not null
constraint PK_stuNo primary key(stuNo)
constraint FK_stuNo foreign key(stuNo) references stuInfo(stuNo),
--笔试成绩
writtenExam int not null
constraint CK_writtenExam check(writtenExam between 0 and 100),
--机试成绩
LabExam int not null
constraint CK_LabExam check(LabExam between 0 and 100)
)
--创建学生成绩表
create table stuMarks
(
--考号
ExamNo char(7) not null
constraint PK_ExamNo primary key(ExamNo),
--学号
stuNo nvarchar(20) not null
constraint PK_stuNo primary key(stuNo)
constraint FK_stuNo foreign key(stuNo) references stuInfo(stuNo),
--笔试成绩
writtenExam int not null
constraint CK_writtenExam check(writtenExam between 0 and 100),
--机试成绩
LabExam int not null
constraint CK_LabExam check(LabExam between 0 and 100)
)
create table stuMarks
(
--考号
ExamNo char(7) not null,
--学号
stuNo nvarchar(20) not null,
--笔试成绩
writtenExam int not null,
--机试成绩
LabExam int not null,
constraint PK_ExamNo primary key(ExamNo,stuNo),
constraint FK_stuNo foreign key(stuNo) references stuInfo(stuNo),
constraint CK_writtenExam check(writtenExam between 0 and 100),
constraint CK_LabExam check(LabExam between 0 and 100)
)未测试
create table stuMarks
(
--考号
ExamNo char(7) not null,
stuNo nvarchar(20) not null,
constraint PK_stuNo primary key(stuNo,ExamNo), --复合主键
constraint FK_stuNo foreign key(stuNo) references stuInfo(stuNo),
--笔试成绩
writtenExam int not null,
constraint CK_writtenExam check(writtenExam between 0 and 100),
--机试成绩
LabExam int not null,
constraint CK_LabExam check(LabExam between 0 and 100)
)
很多地方还缺少逗号