ACCP7.0优化myschool数据库设计
来源:才华咖 本文已影响1.21W人
来源:才华咖 本文已影响1.21W人
ACCP课程体系通过结合先进的多模式教学法,使学习者在掌握理论知识与工具的同时,具备良好的自我学习能力和个人素质,成为符合21世纪企业要求的IT人才。下面是关于ACCP7.0优化myschool数据库设计,欢迎大家参考!
上机1
use MySchool
go
begin transaction
declare @errornum int
set @errornum=0
insert into Result values('23219',1,90,'2013-09-12')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2013-09-13')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2014-09-12')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2013-09-11')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2003-09-12')
set @errornum+=@@ERROR
if @errornum<>0
begin
print '操作失败,回滚事务'
rollback transaction
end
else
begin
print '操作成功,保存事务'
commit transaction
end
--上机2
go
begin transaction
declare @errornum int
set @errornum=0
select * into historyresult from Result
where StudentNo in(select StudentNo from Student
where GradeId=(select GradeId from Grade where GradeName='Y2'))
set @errornum+=@@ERROR
delete from Result
where StudentNo in(select StudentNo from Student
where GradeId=(select GradeId from Grade where GradeName='Y2'))
set @errornum+=@@ERROR
select * into historystudent from Student
where GradeId=(select GradeId from Grade where GradeName='Y2')
set @errornum+=@@ERROR
delete from Student
where GradeId=(select GradeId from Grade where GradeName='Y2')
set @errornum+=@@ERROR
if @errornum<>0
begin
print '操作失败,回滚事务'
rollback transaction
end
else
begin
print '操作成功,保存事务'
commit transaction
end
--上机3
go
CREATE VIEW vw_student_result_info
AS
SELECT 姓名=StudentName,学号=entNo,
联系电话=Phone,学期=GradeName,成绩=Total
FROM Student
LEFT OUTER JOIN (
SELECT entNo,GradeName,SUM(StudentResult) Total
FROM Result r
INNER JOIN (
SELECT StudentNo,SubjectId,MAX(ExamDate) ExamDate
FROM Result
GROUP BY StudentNo,Subjectid) tmp
ON Date=Date
AND ectid = ectid AND entNo = entNo
INNER JOIN Subject sub ON ectid = ectid
INNER JOIN Grade g ON eId = eId
GROUP By entNo,GradeName ) TmpResult2
ON entNo = entNo
GROUP BY StudentName,entNo,Phone,GradeName,Total
GO
SELECT * FROM vw_student_result_info
--上机4
go
create nonclustered index index_result
on result(studentresult)
select studentname,Subjectname,ExamDate,StudentResult from Result
with(index=index_result)
inner join Student on entNo=entNo
inner join Subject on ectId=ectId
where StudentResult between 80 and 90
Some words for this special occasion英文美文欣赏
my happy school life英语作文
「雅思写作」the Growth Cycle of A Volcanic Island
如何用Photoshop CC中的Camera Raw来进行后期修图
《Welcome back to school》第三课时教案
Scott Mitchell 的ASP.NET 2.0数据教程
初中英语What time do you go to school的教案设计
my happy school life英语作文范文
少儿英语小故事:She Practices Flips for the Olympic
人教PEP版小学五年级英语下册Unit3Myschoolcalender.ALet’stalk
英语美文:Olympic Fund Scratchcard Launched
六年级英语Unit 1 Welcome back to school教学设计
Welcome back to school 英语教学反思范文
How my school life has changed英语作文
英语教案:Welcome back to school
Linux+Apache+Mysql+PHP优化技巧
数据库设计心得体会(精选多篇)
ACCP7.0优化myschool数据库设计
英语作文:A Happy School Trip
Lesson4Whatdidyoudoafterschool五年级英语教学设计
人物性格分析 The Analysis of Personal Character英语作文
小学英语课教案范文:Come to see my uncle’s family!
PEP六上Unit2 Ways to go to school教学反思
Academic Dishonesty on Campus英语作文
my school day英语作文
英语《Module 6 Unit 1 You can play football well》的教案设计
PHP数据库Oracle数据完整性
英语作文My English classroom
高中生优秀英语作文:Have a break away from electronics
数据库设计师岗位职责
Cramming School英语作文
Zend studio for eclipse中使php可以调用mysql相关函数的设置方
Oracle数据库SQLPLUS介绍
成人学位英语考试常考词汇:compromise和chalk
sqlplus如何访问远程oracle数据库
初一上册英语第五单元知识点:Do you have a soccerball
My English classroom英语作文
Module 3 Unit 2 I love my pocket calculator说课稿
accomplish是什么中文意思
用云计算数据库进行的数据库设计论文