1)创建视图
--------------------------------
---------视图操作---------------
--------------------------------
use stuDB
if exists (select * from sysobjects where name='view_stuInfo_stuMarks')
drop view view_stuInfo_stuMarks
go
create view view_stuInfo_stuMarks
as
select 姓名=stuInfo.stuName,学号=stuInfo.stuNo,笔试成绩=stuMarks.writtenExam,机试成绩=stuMarks.labExam
from stuInfo inner join stuMarks
on stuInfo.stuNo=stuMarks.stuNo
go
select * from view_stuInfo_stuMarks
2)使用存储过程刷新视图
EXEC [sys].[sp_refreshview] View_Scores
OR
EXEC [sys].[sp_refreshsqlmodule] View_Scores