建个视图跨库查询 CREATE VIEW YourView AS SELECT sLoginUser FROM FROM opendatasource('SQLOLEDB','data source=.;user id=sa;password=').B.dbo.tabLoginInfo string SQL="Select UserID from FFTT_UserInfo a";//来自A库A表 SQL+="left join YourView b on a.Userid=b.sLoginUser";
data source改成你对应的服务器地址
把A库中的值提取出来,然后遍历这里的数据,在遍例中把取出来的值加到string sql="SELECT sLoginUser FROM tabLoginInfo "; //来自B库 这里进行对比..
where tabLoginInfo.sLoginUser=FFTT_UserInfo.UserID"
Select UserID from FFTT_UserInfo
use B
.....
(1,2,3,4,5) 这样,然后in 一下,不过这样效率什么的得考虑一下~~~~
CREATE VIEW YourView AS
SELECT sLoginUser FROM
FROM opendatasource('SQLOLEDB','data source=.;user id=sa;password=').B.dbo.tabLoginInfo string SQL="Select UserID from FFTT_UserInfo a";//来自A库A表
SQL+="left join YourView b on a.Userid=b.sLoginUser";
这里进行对比..