SQL Server 中使用其它数据库表示例

--读取Access数据库
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\ssm.mdb";User ID=Admin;Password=')...h_info

--读取Visual FoxPro DB
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=e:',
'select * from lskzczb')

--读取Visual FoxPro DB
select * into #t from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=e:',
'select * from lskzczb')