一个视图里能查一个存储过程吗？

Question

像这样：
use stuDB
GO
if exists(select * from sysobjects where name='view_stuInfo_stuMarks')
drop view view_stuInfo_stuMarks
GOcreate view view_stuInfo_stuMarks
as
select name=stuName,no=stuInfo.stuNo,Ascore=writtenExam,Bscore=labExam,proc_select from stuInfo left join stuMarks on stuInfo.stuNo=stuMarks.stuNo
GO

Answer 1

use stuDB
GO
if exists(select * from sysobjects where name='view_stuInfo_stuMarks')
drop view view_stuInfo_stuMarks
GOcreate view view_stuInfo_stuMarks
as
select name=stuName,no=stuInfo.stuNo,Ascore=writtenExam,Bscore=labExam,proc_select as 平均成绩 from stuInfo left join stuMarks on stuInfo.stuNo=stuMarks.stuNo
GO