INSERT INTO Subject(SubjectName,ClassHour,GradeId)
VALUES('走进JAVA编程世界',40,1)
INSERT INTO Subject(SubjectName,ClassHour,GradeId)
VALUES('HTML与CSS技术',60,1)
INSERT INTO Subject(SubjectName,ClassHour,GradeId)
VALUES('C#语言和数据库技术',70,1)
SELECT SubjectName,ClassHour,GradeId
INTO Subject
FROM Grade