保存一段从Baan ERP LN的Oracle数据库中导出数据到SQL Server的SQL语句,前提是在MSSQL 2005中建立Link Server。...> ,qana ,cwar ,cpha ,scpf ,scpq)SELECT *FROM OPENQUERY...csig ,ctyp ,ctyo ,cpcl ,cean ,lmdt )SELECT *FROM OPENQUERY...br/>Insert into LNtdipu001(item,cuqp,cupp,ccur,prip,otbp,buyr,cofc,suti)SELECT *FROM OPENQUERY...Truncate Table LNtcibd004Insert into LNtcibd004(citt,bpid,item,aitc)SELECT *FROM OPENQUERY