ASP如何调用SQL视图

跟读取数据表中的方法一样

Sql语句写为

Select * From 视图名

比如我有两个表a和b,视图myview是用a和b两个表建立的

那么我要调用这个视图就用:

Select * From myview

下面是我的一个视图实例"Topstarts"(只有代码),两个表University和Users:

SELECT dbo.University.University_ID, dbo.University.University_Name,
dbo.Users.User_ID, dbo.Users.Truename, dbo.Users.Picture,
dbo.Users.LastLogin
FROM dbo.University INNER JOIN
dbo.Users ON dbo.University.University_ID = dbo.Users.University

下面是我程序调用的部分代码:

<tr>
<%
Set Rs=conn.Execute("Select top 8 User_ID,Picture,Truename From [Topstarts] Where University_ID="&Session("University")&" Order By LastLogin DESC")
Do While Not Rs.Eof
%>
<td align="center"><img src="<%=Rs("Picture")%>" width="50" class="