|
執(zhí)行1. 為開啟所需服務;成功后執(zhí)行3.進行導數(shù)據(jù);執(zhí)行完后關閉服務,執(zhí)行2. 1.啟用Ad Hoc Distributed Queries: exec sp_configure 'show advanced options',1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure 2.為了安全使用完成后,關閉Ad Hoc Distributed Queries: exec sp_configure 'Ad Hoc Distributed Queries',0 reconfigure exec sp_configure 'show advanced options',0 reconfigure 3. INSERT TPOLPDTPLNH SELECT * FROM OPENROWSET('SQLOLEDB','10.69.4.53\ebenefitqa';'dev';'developer',eCompassSGP132QA.DBO.TPOLPDTPLNH) |
|
|
來自: kzq4 > 《Java 開發(fā)》