List the different types of joins?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

Define master database?

0 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

How do you check sql server is up and running?

0 Answers  

---

What is difference between delete & truncate commands?

0 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

How to insert data with null values?

0 Answers  

---

What is ssl in sql server?

0 Answers  

---