SQL Server关系表的创建、索引创建和数据插入(二)
(CNO,CNAME,CPNO,CCREDIT) VALUES(2,'数学',NULL,4);
3 INSERT INTO COURSE(CNO,CNAME,CPNO,CCREDIT) VALUES(3,'信息
系统',1,4);
4 INSERT INTO COURSE(CNO,CNAME,CPNO,CCREDIT) VALUES(4,'操作系统',NULL,3);
5 INSERT INTO COURSE(CNO,CNAME,CPNO,CCREDIT) VALUES(5,'数据结构',NULL,4);
6 INSERT INTO COURSE(CNO,CNAME,CPNO,CCREDIT) VALUES(6,'数据处理',NULL,2);
7 INSERT INTO COURSE(CNO,CNAME,CPNO,CCREDIT) VALUES(7,'PASCAL语言',NULL,4);
8 UPDATE COURSE SET CPNO=5 WHERE CNO=1;
9 UPDATE COURSE SET CPNO=6 WHERE CNO=4;
10 UPDATE COURSE SET CPNO=7 WHERE CNO=5;
11 UPDATE COURSE SET CPNO=6 WHERE CNO=7;
/***************************************************
为选课表SC插入数据 www.2cto.com
****************************************************/
1 INSERT INTO SC(SNO,CNO,GRADE) VALUES('200215121',1,92);
2 INSERT INTO SC(SNO,CNO,GRADE) VALUES('200215121',2,85);
3 INSERT INTO SC(SNO,CNO,GRADE) VALUES('200215121',3,88);
4 INSERT INTO SC(SNO,CNO,GRADE) VALUES('200215122',2,90);
5 INSERT INTO SC(SNO,CNO,GRADE) VALUES('200215122',3,80);