在同个SQL Server中:
CREATE proc book as
select * from news as a INNER JOIN ceshi1.dbo.news as b on a.artical=b.artical
CREATE proc book as
select * from news as a INNER JOIN ceshi1.dbo.news as b on a.artical=b.artical
<!--#include file="adovbs.inc"-->
<table border="0" cellpadding="0" style="border-collapse: collapse" width="90%" id="AutoNumber3">
<%
set conn=server.createobject("ADODB.connection")
set conn1=server.createobject("ADODB.connection")
conn.open"PROVIDER=SQLOLEDB;DATASOURCE=localhost;UID=sa;PWD=;DATABASE=ceshi"
conn1.open"PROVIDER=SQLOLEDB;DATASOURCE=localhost;UID=sa;PWD=;DATABASE=ceshi2"
Dim strSQLCondition,cmd,rs
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "book" '存储过程名
cmd.CommandType = adCmdStoredProc
Set RS = cmd.Execute()
While Not RS.EOF
%>
<tr>
<td height="24">
<a href="xinwen_xx.asp?" target="_blank"><%=RS("maxi")%></a></td>
</tr>
<%
RS.MoveNext
WEnd
Set RS = Nothing
%>
</table>
<%
Set conn = Nothing
%>
存储过程:
CREATE proc book as
select * from madong as a INNER JOIN ceshi2.dbo.madong as b on a.maxi=b.maxi
GO为什么啊 大家帮帮我哦