其实这个实验应该上个星期做的
视图
CREATE VIEW Stu_01311_1
AS SELECT Student.*
FROM Student, Grade
WHERE Student.Sno = Grade.Sno
AND Grade.Cno = 1
AND Student.Clno = '01311'
典型的创建视图
CREATE VIEW 视图名称 [列名清单]
AS 子查询
注意,这里的列名清单大部分时候都是需要的,只有当子查询直接从单个表中导出的时候才可以省略。其他时候都要有
CREATE VIEW stu_year(Sno, Sname, Sbirthyear)
AS SELECT Student.Sno, Student.Sname,year(GETDATE())