SQL Quick tip - OpenQuery
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:
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.com
- 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.com
Labels: Dynamics AX, OpenQuery, Quick Tip, SQL
posted by brandon | 9:36 PM
0 Comments:
Post a Comment
<< Home