首页 › Access › SQL 远程访问 和 文件访问示例

oracle_api 发表于 2013-1-29 22:21:00

SQL 远程访问 和 文件访问示例

Remote Access

select * from opendatasource('sqloledb','server=192.168.1.1;uid=sa;pwd=123456;database=TT').TT.dbo.test1

select top 10 * from opendatasource('sqloledb','Data Source=MSOutputDB3;Initial Catalog=TimeSeries;;Integrated Security=SSPI;').TimeSeries.dbo.NetAssets
-----------------------------------------------------------------------------------

File access sample

schema.ini Sample

ColNameHeader = True
Format=TabDelimited
MaxScanRows=0

select SecId+',' from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=D:\Data;Format=TabDelimited;',
'select * from ')

select SecId,Year
from opendatasource('sqloledb','Data Source=MSOutputDB3;Initial Catalog=TimeSeries;;Integrated Security=SSPI;').TimeSeries.dbo.NetAssets
where SecIdin
(select SecId from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Data;Format=TabDelimited;',
'select * from '))

----------------------------------------------------------------------------------
Another sample

select   *   from   
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'   
,'Text;HDR=Yes;DATABASE=D:\Data\FullIdList'
,'select * from ')

查看完整版本: SQL 远程访问 和 文件访问示例