摘要:
CREATE VIEW view_name AS IF EXISTS (SELECT * FROM sysobjects WHERE /*检测是否存在*/ name = 'view_stuInfo_stuMarks') DROP VIEW view_stuInfo_stuMarks /*删除视图*/GOCREATE VIEW view_stuInfo_stuMarks /*创建视图*/ AS SELECT 姓名=stuName,学号=stuInfo.stuNo, 笔试成绩 =writtenExam, 机试成绩=labExam, 平均分=(writtenExam+labExam) 阅读全文