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  

---

What is default port number for sql server 2000?

0 Answers  

---

What is a transact-sql statement?

0 Answers  

---

Explain transaction isolation levels in sql server?

0 Answers  

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

What are the advantages of log shipping?

0 Answers  

---

what is the difference between procedure and function.

4 Answers   Thomson,

---

Describe about first three Normal forms.

1 Answers   HP,

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

Define cross join in sql server joins?

0 Answers  

---