Answer / guest

We can link any server provided we have the OLE-DB provider
from Microsoft to allow a link. For Oracle we have a OLE-DB
provider for oracle that microsoft provides to add it as a
linked server to the sql server group.

How to delete duplicate rows from table except one?

0 Answers  

---

What are different type of Collation Sensitivity?

0 Answers  

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

How do I open a .db file?

0 Answers  

---

---

Write a sql query to display the current date?

0 Answers  

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

How to create Clustered Primary Key to table?

2 Answers  

---

What are the advantages of partitioning?

0 Answers  

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---