What are the different types of replication? How are they used?

3 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

How to provide default values to stored procedure parameters?

0 Answers  

---

---

How do you know which index a table is using?

4 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

Why use sub query in sql server and list out types of sub queries?

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

Why Master database is required?

0 Answers   Abacus,

---