opendataSource 应用实例

select  
a.SeatNo,a.IP,a.StartTime,a.EndTime,a.Rate,a.Fare,a.AddFare,a.TotalFare,a.OtherFare,
a.PreFare,a.FactFare,a.OnCardNo,a.PayTime,a.ChangeTime,a.Notice,a.MemberFlag,a.name,
a.LabelNub,a.HostName,a.MemberRatio,a.MemberOtherTime,a.TransferMoney,a.ViewFlag,
a.FAM,a.sn,a.Certificate,a.CertificateNo,a.id


from 
(select 
SeatNo,IP,StartTime,EndTime,Rate,Fare,AddFare,TotalFare,OtherFare,PreFare,
FactFare,OnCardNo,PayTime,ChangeTime,Notice,MemberFlag,name,LabelNub,HostName,
MemberRatio,MemberOtherTime,TransferMoney,ViewFlag,FAM,sn,Certificate,CertificateNo,id
from 
opendataSource (
'Microsoft.Jet.OLEDB.4.0',
'data source="C:/dbWatcher/bardb.mdb";
Jet OLEDB:DataBase Password=HCbg3721k')
...seathistory
) a 
left outer join seathistory s  on a.id = s.id
where  s.id  is null






--启用Ad Hoc Distributed Queries：


exec sp_configure "show advanced options",1


reconfigure


exec sp_configure "Ad Hoc Distributed Queries",1


reconfigure