跨引擎库查询

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
posted @ 2011-06-17 14:45  刘颖  阅读(73)  评论(1编辑  收藏