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 are dml (data manipulation language) statements in ms sql server?

0 Answers  

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

How to list all schemas in a database?

0 Answers  

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

What are group functions in query statements in ms sql server?

0 Answers  

---

Explain what are the events recorded in a transaction log?

0 Answers  

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

Do you know nested transaction?

0 Answers  

---