What are the advantages of using cte?

0 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

What is key set driven?

0 Answers  

---

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Can sql servers linked to other servers like oracle?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

What is dirty read?

0 Answers  

---

What is co-related sub query?

0 Answers  

---