accp课程体系通过结合先进的多模式教学法，使学习者在掌握理论知识与工具的同时，具备良好的自我学习能力和个人素质，成为符合21世纪企业要求的it人才。下面是关于accp7.0优化myschool数据库设计，欢迎大家参考!
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
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
go
create view vw_student_result_info
as
select 姓名=studentname,学号=tno,
联系电话=phone,学期=gradename,成绩=total
from student
left outer join (
select tno,gradename,sum(studentresult) total
from result r
inner join (
select studentno,subjectid,max(examdate) examdate
from result
group by studentno,subjectid) tmp
on te=te
and tid = tid and tno = tno
inner join subject sub on tid = tid
inner join grade g on d = d
group by tno,gradename ) tmpresult2
on tno = tno
group by studentname,tno,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 tno=tno
inner join subject on tid=tid
where studentresult between 80 and 90
s("content_relate");【accp7.0优化myschool数据库设计】相关文章：
1.accp7.0课程大纲2.大连accp7.0培训机构3.accp7.0软件工程师课程4.accp7.0课程体系5.accp7.0和accp6.0的区别6.accp7.0课程介绍7.accp7.0软件课程有什么优势8.accp7.0课程定位及优势
