CTE(common table expression)

1 Answers   Thomson Reuters,

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

What is scalar user-defined function?

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

How to convert numeric expression data types by assignment operations?

0 Answers  

---

What is raid, and how it can influence database performance?

0 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---