T-SQL---视图

if exists(select * from sysobjects where name='view_stuInfo_stuMarks')
 drop view view_stuInfo_stuMarks
go
create view view_stuInfo_stuMarks as 
select 姓名=stuName,学号=stuInfo.stuNo,笔试成绩＝writtenExam,机试成绩=labExam,平均分＝（writtenExam+labExam）/2 from stuInfo left join stuMarks on stuInfo.stuNo=stuMarks.stuNo
go
select * from view_stuInfo_stuMarks