ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
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?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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?
Answer
# 1		 
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 ?    1 Yes 0 No
Guest
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is physical sort data and logical sort data in index?  1
What about UPDATESTATISTICS ? Intelligroup1
Alternative way to DetDate() function?  2
How do you use DBCC statements to monitor various aspects of a SQL server installation?  1
Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?  1
Which stored procedure will you be running to add a linked server?  1
how to select a field with firstletter as capital and remaining are small letters  7
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.  1
IN Vs OR operator which is best to use sql server.  3
how to get the automatic backup of the database in the sql server  3
create index a on employee(dno) In this,which index was created?  1
When do you use SQL Profiler?  2
What is mean by "fill factor" ? and what is mean by "Index "in sql? Logica-CMG1
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?  2
what are the problems in logshipping?  2
explain different types of jions with examples briefly? Zensar3
what operator performs pattern matching?  1
What are the two types of concurrency?  2
What is The Use Of TIMESTAMP DataType in SQL Server 2005?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com