• <sub id="h4knl"><ol id="h4knl"></ol></sub>
    <sup id="h4knl"></sup>
      <sub id="h4knl"></sub>

      <sub id="h4knl"><ol id="h4knl"><em id="h4knl"></em></ol></sub><s id="h4knl"></s>
      1. <strong id="h4knl"></strong>

      2. ACCP7.0優化myschool數據庫設計

        時間:2024-10-13 22:27:07 ACCP培訓 我要投稿
        • 相關推薦

        ACCP7.0優化myschool數據庫設計

          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,學號=Student.StudentNo,

          聯系電話=Phone,學期=GradeName,成績=Total

          FROM Student

          LEFT OUTER JOIN (

          SELECT r.StudentNo,GradeName,SUM(StudentResult) Total

          FROM Result r

          INNER JOIN (

          SELECT StudentNo,SubjectId,MAX(ExamDate) ExamDate

          FROM Result

          GROUP BY StudentNo,Subjectid) tmp

          ON r.ExamDate=tmp.ExamDate

          AND r.Subjectid = tmp.Subjectid AND r.StudentNo = tmp.StudentNo

          INNER JOIN Subject sub ON sub.Subjectid = r.Subjectid

          INNER JOIN Grade g ON g.GradeId = sub.GradeId

          GROUP By r.StudentNo,GradeName ) TmpResult2

          ON Student.StudentNo = TmpResult2.StudentNo

          GROUP BY StudentName,Student.StudentNo,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 Student.StudentNo=Result.StudentNo

          inner join Subject on Subject.SubjectId=Result.SubjectId

          where StudentResult between 80 and 90

        《&.doc》
        将本文的Word文档下载到电脑,方便收藏和打印
        推荐度:
        点击下载文档

        【ACCP7.0優化myschool數據庫設計】相關文章:

        大連ACCP7.0培訓機構01-10

        ACCP7.0課程介紹09-10

        ACCP7.0軟件課程有什么優勢06-12

        2016最數據庫設計技巧08-01

        環境設計的優化與具體應用09-10

        SEO網站設計中的優化策略08-21

        SEO在網站設計中的優化策略08-25

        模具設計制造的常見優化方法09-15

        2016年數據庫設計技巧大全04-20

        淺談WLAN網絡容量性能設計和優化07-23

        国产高潮无套免费视频_久久九九兔免费精品6_99精品热6080YY久久_国产91久久久久久无码
      3. <sub id="h4knl"><ol id="h4knl"></ol></sub>
        <sup id="h4knl"></sup>
          <sub id="h4knl"></sub>

          <sub id="h4knl"><ol id="h4knl"><em id="h4knl"></em></ol></sub><s id="h4knl"></s>
          1. <strong id="h4knl"></strong>

          2. 亚洲日本欧洲精品 | 制服肉丝袜亚洲中文字幕 | 亚洲综合中文字幕在线专区 | 亚洲视频一区二区在线观看 | 了久久国产精品久久 | 亚洲中文乱码字幕不卡 |

            ACCP7.0優化myschool數據庫設計

              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,學號=Student.StudentNo,

              聯系電話=Phone,學期=GradeName,成績=Total

              FROM Student

              LEFT OUTER JOIN (

              SELECT r.StudentNo,GradeName,SUM(StudentResult) Total

              FROM Result r

              INNER JOIN (

              SELECT StudentNo,SubjectId,MAX(ExamDate) ExamDate

              FROM Result

              GROUP BY StudentNo,Subjectid) tmp

              ON r.ExamDate=tmp.ExamDate

              AND r.Subjectid = tmp.Subjectid AND r.StudentNo = tmp.StudentNo

              INNER JOIN Subject sub ON sub.Subjectid = r.Subjectid

              INNER JOIN Grade g ON g.GradeId = sub.GradeId

              GROUP By r.StudentNo,GradeName ) TmpResult2

              ON Student.StudentNo = TmpResult2.StudentNo

              GROUP BY StudentName,Student.StudentNo,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 Student.StudentNo=Result.StudentNo

              inner join Subject on Subject.SubjectId=Result.SubjectId

              where StudentResult between 80 and 90