跨引擎库查询

select a.* from openrowset('SQLOLEDB','192.168.1.1\Sqlexpress';'sa';'123456','select  * from temp.dbo.Act as a where a.actid in(11,22,33,33) roder by id') a  inner join dbo.newtemp b on b.id=a.id

转载于:https://www.cnblogs.com/liuying/archive/2011/06/17/2083615.html