use StudentManager

 go

 --判断视图是否存在

 if exists(select * from sysobjects where name='view_ScoreQuery')

 drop view view_ScoreQuery

 go

 --创建视图

 create view view_ScoreQuery

 as

     select top 1000 Students.StudentId,StudentName,ClassName,

              C#=CSharp,SQLDB=SQLServerDB,

              ScoreSum=(CSharp+SQLServerDB) from Students

              inner join ScoreList on Students.StudentId=ScoreList.StudentId

              inner join StudentClass on Students.ClassId=StudentClass.ClassId

              order by StudentClass.ClassId

 go

 --使用视图查询

 select * from view_ScoreQuery