Fork me on GitHub
摘要: 1 use 待导入DB 2 go 3 4 /*启动Ad Hoc Distributed Queries*/ 5 exec sp_configure 'show advanced options',1 6 reconfigure 7 exec sp_configure 'Ad Hoc Distributed Queries',1 8 reconfigure 9 10 insert into 待导入DB.dbo.表名11 select top 10 sid from opendatasource('SQLOLEDB','data source 阅读全文
posted @ 2012-03-28 12:04 磊哥|www.javacn.site 阅读(382) 评论(0) 推荐(0) 编辑