What is the difference between for xml raw and for xml auto?

0 Answers  

---

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

---

what protocol both networks use? : Sql server database administration

0 Answers  

---

What are .mdf files?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

Why do we use stored procedures in sql server?

0 Answers  

---

How do you create type- insensitive operator?

0 Answers   EXL,

---

What does ss stand for sexually?

0 Answers  

---

What is the purpose of update statistics and scope_identity() function?

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,

---

Does index slows down insert statements?

0 Answers  

---