Dynamics AX: SQL Quick tip - OpenQuery

[Blog bot]

Источник: 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