Источник:
http://dynamics-ax.blogspot.com/2007...openquery.html
==============
Alright, it's been a while since I had to do this, but just in case. If you are in an implementation and you happen to be moving data from Oracle or and AS/400 and want to query the tables and views, first:
- Take and create a linked Server, with the correct provider to the database.
- Make sure to make use of the openquery syntax
The syntax for openquery goes:
select * from openquery(Linked_Server,'Select Statement')
This will save a lot of pain, and allow the other server to handle servering up table attributes, data types and the likes that will cause issues if you try a standard linked server, FQN statement. :-)
Check back soon!
Find a job at:
www.DynamicsAXJobs.comFind a job at:
DynamicsAXJobs.com, also post a job for only $99.00!
==============
Источник:
http://dynamics-ax.blogspot.com/2007...openquery.html