前提在D盘下建一aa.txt文档里面输入几个数据 每个数据占用一行
create table test(num int not null)
insert into test select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Text;HDR=NO;DATABASE=D:\' ,aa#txt)
select * from test
delete test
启用Ad Hoc Distributed Queries:
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
使用完成后,关闭Ad Hoc Distributed Queries:
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
SQL查询分析器SQL语句导入TXT文件
最新推荐文章于 2020-06-30 17:05:44 发布