Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

How to insert multiple rows with a subquery?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

Explain different types of Normalization.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How to create an index on an existing table in ms sql server?

0 Answers  

---

---

Is the order of columns in the set clause important in ms sql server?

0 Answers  

---

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

7 Answers   Microsoft,

---

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

---

What are cursors and when they are useful?

0 Answers  

---

What is dbcc? Give few examples.

0 Answers  

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

---

What is the difference between a function and a trigger?

0 Answers  

---