sql 语句 中 消息 102，级别 15，状态 1，第 5 行 是什么错误

create Table Student
(Sno CHAR(5) NOT NULL PRIMARY KEY(Sno),
 Sname VARCHAR(20),
 Sage SMALLINT CHECK(Sage>=15 AND Sage<=45)
 Ssex CHAR(2) DEFAULT '男' CHECK (Ssex='男' OR Ssex='女'),
Sdept CHAR(2));
create Table Course
( Cno CHAR(2) NOT NULL PRIMARY KEY(Cno),
 Cname VARCHAR(20),
 Cpno CHAR(2),
 Ccredit SMSLLINT);
create Table SC
(Sno CHAR(5) NOT NULL CONSTRAINT S_F FOREIGN KEY REFERENCES 学生表(Sno),
Cno CHAR(2) NOT NULL,
Grade SMALLINT CHECK((Grade IS NULL) OR (Grade BETWEEN 0 AND 100)),
PRIMARY KEY (Sno,Cno), FOREIGN KEY (Cno) REFERENCES Course(Cno));
INSERT INTO Student VALUES('98001','钱横','18','男','CS');
INSERT INTO Student VALUES('98002','王林','19','女','CS');
INSERT INTO Student VALUES('98003','李民','20','男','IS');
INSERT INTO Student VALUES('98004','赵三','16','女','MA');
INSERT INTO Course VALUES('1','数据库系统','5',4);
INSERT INTO Course VALUES('2','数学分析',null,2);
INSERT INTO Course VALUES('3','信息系统导论','1',3);
INSERT INTO Course VALUES('4','操作系统原理','6',3);
INSERT INTO Course VALUES('5','数据结构','7',4);
INSERT INTO Course VALUES('6','数据处理基础',null,4);
INSERT INTO Course VALUES('7','c语言','6',3);
INSERT INTO SC VALUES('98001','1',87);
INSERT INTO SC VALUES('98001','2',67);
INSERT INTO SC VALUES('98001','3',90);
INSERT INTO SC VALUES('98002','2',95);
INSERT INTO SC VALUES('98002','3',88);


为什么会有错误啊
消息 102，级别 15，状态 1，第 5 行
'Ssex' 附近有语法错误。

少了个逗号。

SQL code

create Table Student
(Sno CHAR(5) NOT NULL PRIMARY KEY(Sno),
 Sname VARCHAR(20),
 Sage SMALLINT CHECK(Sage>=15 AND Sage<=45),
 Ssex CHAR(2) DEFAULT '男' CHECK (Ssex='男' OR Ssex='女'),
Sdept CHAR(2));

SQL code

create Table Student
(Sno CHAR(5) NOT NULL PRIMARY KEY(Sno),
 Sname VARCHAR(20),
 Sage SMALLINT CHECK(Sage>=15 AND Sage<=45),
 Ssex CHAR(2) DEFAULT '男' CHECK (Ssex='男' OR Ssex='女'),
Sdept CHAR(2));
go
create Table Course
( Cno CHAR(2) NOT NULL PRIMARY KEY(Cno),
 Cname VARCHAR(20),
 Cpno CHAR(2),
 Ccredit smallint);
 go
create Table SC
(Sno CHAR(5) NOT NULL CONSTRAINT S_F FOREIGN KEY REFERENCES Student(Sno),
Cno CHAR(2) NOT NULL,
Grade SMALLINT CHECK((Grade IS NULL) OR (Grade BETWEEN 0 AND 100)),
PRIMARY KEY (Sno,Cno), FOREIGN KEY (Cno) REFERENCES Course(Cno));

少了逗号，字段类型,引用表 3处改改
Ssex CHAR(2) DEFAULT '男' CHECK (Ssex='男' OR Ssex='女'),
 Ccredit smallint
(Sno CHAR(5) NOT NULL CONSTRAINT S_F FOREIGN KEY REFERENCES Student(Sno),

谢谢各位老师啊

写的时候最好在查询分析器中写,而且写都好,括号时最好一次成对的写,这样会减少出错的概率

恩 新人要学会结贴