恩select * from 数据库名.表名.字段名,其实跟查不同的表是一样的,只不过在表前面多加个数据库名就行了
declare @value as varchar(10) set @value = 'xxx '--变量值 select A.* from aa A inner join (select * from openrowset( 'sqloledb ', 'B '; 'misa '; '** ', 'select * from B.dbo.bb) as B on A.a = B.b where A.a = @value
set @value = 'xxx '--变量值
select A.* from aa A
inner join (select * from openrowset( 'sqloledb ', 'B '; 'misa '; '** ', 'select * from B.dbo.bb) as B
on A.a = B.b
where A.a = @value