Select * Into #Temp_table
From (Exec B) RCreate table #Temp_table(...表结构..)
insert into #Temp_table exec Bselect * from #Temp_table
where ...条件....drop table #Temp_table
From (Exec B) RCreate table #Temp_table(...表结构..)
insert into #Temp_table exec Bselect * from #Temp_table
where ...条件....drop table #Temp_table
SELECT a.*
FROM OPENROWSET('SQLOLEDB','服务器名或IP';'用户名';'密码',
'exec 数据库名.dbo.过程名') AS a