Interested to Buy Any Domain ? << Click Here >> for more details...
I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
- 1 Answers
- 6517 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
To query to different data sources, you can make the Oracle
server a linked server to the SQL Server server. A linked
server can be any OLE DB data source and SQL Server
currently supports the OLE DB data provider for Oracle. You
can add a linked server by calling sp_AddLinkedServer and
query information about linked servers with sp_LinkedServers.
An easier way to add a linked server is to use Enterprise
Manager. Add the server through the Linked Servers icon in
the Security node. Once a server is linked, you can query it
using a distributed query (you have to specify the full name).
Here's an example of a distributed query (from the SQL
Server Books Online) that queries the Employees table in SQL
Server and the Orders table from Oracle:
SELECT emp.EmloyeeID, ord.OrderID, ord.Discount
FROM SQLServer1.Northwind.dbo.Employees AS emp,
OracleSvr.Catalog1.SchemaX.Orders AS ord
WHERE ord.EmployeeID = emp.EmployeeID
AND ord.Discount > 0
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the return type of executeupdate ()?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
what exactly sql injuction.how to overcome.....
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain the truncate command? : SQL Server Architecture
What is difference between views and stored procedures?
Using the customer, and order table in northwind database, please write a query to produce xml?
Explain about SQL server 2005?
What is sql view?
What are the differences between lost updates and uncommitted dependencies?
Explain logical operators in sql server?
What does it mean to normalize a database and why would you do it?
What is the syntax for encrypting a column in SQL Server?
what is the system function to get the current user's user id? : Sql server database administration
