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