第8章

最新推荐文章于 2021-12-09 18:59:36 发布

qq_36024699

最新推荐文章于 2021-12-09 18:59:36 发布

阅读量458

点赞数

本文链接：https://blog.csdn.net/qq_36024699/article/details/53242465

版权

创建通讯录

INSERT INTO Address_IS(Id,SName,Phone,Address,Email)
SELECT GradeId,StudentName,Phone,Address,Email
FROM dbo.Student
SELECT StudentName,Phone,Address,Email
INTO dbo.Address_SI
FROM dbo.Student

删除记录

DELETE FROM dbo.Student
WHERE BornDate<1997-7-1

添加成绩记录

INSERT INTO dbo.Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302001','1','80','2013-9-13')
INSERT INTO dbo.Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302002','1','45','2013-9-13')
INSERT INTO dbo.Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302001','2','90','2013-10-18')
INSERT INTO dbo.Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302002','2','60','2013-10-18')

修改成绩记录

UPDATE dbo.Student SET Address='山东省济南市文化路1号院'
WHERE StudentNo='S1201302004'
UPDATE dbo.Student SET GradeId='2'
WHERE Gradeid='1'
UPDATE dbo.Subject SET ClassHour='55'
WHERE SubjectName='走进Java编程世界'
UPDATE dbo.Result SET StudentResult=StudentResult+5
WHERE StudentResult<60
UPDATE dbo.Result SET StudentResult='55'
WHERE StudentNo='S1201302002'and ExamDate='2013-10-18' 
UPDATE  dbo.Student SET Email='未知@'
WHERE Email is null

添加成绩记录

INSERT INTO dbo.Subject(SubjectName,ClassHour,GradeId)
VALUES('走进Java编程世界','40','1')
INSERT INTO dbo.Subject(SubjectName,ClassHour,GradeId)
VALUES('HTML和CSS网页技术','60','1')
INSERT INTO dbo.Subject(SubjectName,ClassHour,GradeId)
VALUES('C#语言和数据库技术','70','1')

添加学生记录

--INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate,Email)VALUES('S1201302001','zhangsan','张三','男',1,'01062768866','解放路','1991-1-1','zhangsan@126.com')
--INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate)VALUES('S1201302002','lisi89','李四','男',1,'13812345678','长江路','1995-2-1')
--INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate)VALUES('S1201302003',DEFAULT,'王五','男',1,'13912345678',DEFAULT,'1994-5-1')
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate)VALUES('S1201302004',DEFAULT,'王丽丽','女',1,'13112345678',DEFAULT,'1994-6-2')