sqlserver:
exec sp_configure 'show advanced options',1
reconfigureexec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
select a.*,b.tbegin from
openrowset( 'SQLOLEDB', '192.168.1.100'; 'sa'; '123',[zl_hospital].[dbo].[t_personinfo]) a
, openrowset( 'SQLOLEDB', '192.168.1.100'; 'sa'; '123',[zl_hospital].[dbo].[t_use]) b
where a.idno=b.idno