第八章上机

INSERT Student VALUES('S1201302001','zhangsan','张三','男',1,'101062768866','解放路','1991-1-1','zhangsan@126.com')
INSERT Student VALUES('S1201302002','lisi89','李四','男',1,'13812345678','长江路','1991-2-1',null)
INSERT Student VALUES('S1201302003',DEFAULT,'王五','男',1,'13912345678',DEFAULT,'1991-5-3',null)
INSERT Student VALUES('S1201302004','wanglili','王丽丽','女',1,'13112345678',DEFAULT,'1991-6-2','wanglili@sohu.com')
INSERT Student VALUES('S1201302005',DEFAULT,'张峰','男',1,'13212345678',DEFAULT,'1991-8-8',null)
INSERT Subject(SubjectName,ClassHour,GradeId)
SELECT '走进java编程世界',40,1 UNION
SELECT 'HTML和CSS网页技术',60,1 UNION
SELECT 'C#语言和数据库技术',70,1 
INSERT Result(StudentNo,SubjectId,StudentResult,ExamDate)
SELECT 'S1201302001',1,80,'2013-9-13' UNION
SELECT 'S1201302001',1,45,'2013-9-13' UNION
SELECT 'S1201302002',2,90,'2013-10-18' UNION
SELECT 'S1201302002',2,60,'2013-10-18' 
INSERT Address_IS(Id,SName,Phone,Address,Email)
SELECT StudentNo,StudentName,Phone,Address,Email
FROM Student

SELECT StudentName,Phone,Address,Email
INTO Address_SI
FROM Student