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.

What is the difference between TRUNCATE and DROP?

1 Answers  

---

What is a not null constraint?

1 Answers  

---

Differentiate between a local and a global temporary table?

1 Answers  

---

What is difference between join and natural join?

1 Answers  

---

How many columns can exist together per table?

1 Answers   Cap Gemini,

---

When would you use a before or after trigger?

1 Answers  

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

1 Answers  

---

What is ssl in sql server?

1 Answers  

---

what is nonclustered index

1 Answers  

---

What are statistics?

1 Answers  

---

What is the process of indexing?

1 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---