摘要:
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)
阅读全文
posted @ 2014-02-10 17:16
明天521
阅读(224)
推荐(0)
编辑