SQL 远程访问 和 文件访问示例
来源:互联网 发布:湖南青果软件好不好 编辑:程序博客网 时间:2024/06/05 23:59
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
[US_Other_Funds_20090416.txt]
ColNameHeader = True
Format=TabDelimited
MaxScanRows=0
select SecId+',' from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=D:\Data;Format=TabDelimited;',
'select * from [US_Other_Funds_20090416.txt]')
select SecId,Year
from opendatasource('sqloledb','Data Source=MSOutputDB3;Initial Catalog=TimeSeries;;Integrated Security=SSPI;').TimeSeries.dbo.NetAssets
where SecId in
(select SecId from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Data;Format=TabDelimited;',
'select * from [US_Other_Funds_20090416.txt]'))
----------------------------------------------------------------------------------
Another sample
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=Yes;DATABASE=D:\Data\FullIdList'
,'select * from [b.txt]')
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\TEXT]
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
[US_Other_Funds_20090416.txt]
ColNameHeader = True
Format=TabDelimited
MaxScanRows=0
select SecId+',' from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=D:\Data;Format=TabDelimited;',
'select * from [US_Other_Funds_20090416.txt]')
select SecId,Year
from opendatasource('sqloledb','Data Source=MSOutputDB3;Initial Catalog=TimeSeries;;Integrated Security=SSPI;').TimeSeries.dbo.NetAssets
where SecId in
(select SecId from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Data;Format=TabDelimited;',
'select * from [US_Other_Funds_20090416.txt]'))
----------------------------------------------------------------------------------
Another sample
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=Yes;DATABASE=D:\Data\FullIdList'
,'select * from [b.txt]')
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\TEXT]
阅读全文
0 0
- SQL 远程访问 和 文件访问示例
- SQL访问远程数据库
- sql远程访问数据
- 远程访问SQL server
- 远程访问文件
- fopen访问远程文件
- PHP远程访问文件
- SQL Server 2005远程访问
- sql访问远程的数据库
- sql server访问远程数据库
- SQL SERVER 2005 远程访问
- sql server远程访问设置
- sql server2012 远程访问设置
- sql server2012 远程访问设置
- SQL SERVER 远程访问失败
- 通过SQL进行远程访问
- Sql server 2014 远程访问
- T-Sql访问远程数据库
- 启动tomcat时,一直卡在Deploying web application directory这块的解决方案
- LoadRunner字符串编码转换函数:lr_convert_string_encoding
- 数组的栈方法和队列方法
- bat自动映射网盘
- 数据库面试题及答案
- SQL 远程访问 和 文件访问示例
- scikit-learn 0.18.2 中文文档 | ApacheCN
- 5-2 然后是几点 (15分)
- 八步轻松搞定 XPlanner 安裝
- SPOJ 24772 DWARFLOG
- Python009时间日期
- LeetCode
- 计算机图形学 学习笔记(九):曲线曲面(一):参数曲线、参数几何代数形式
- 系统平台、统一用户 jacob_liang