CTE(common table expression)

1 Answers   Thomson Reuters,

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

What is CTE in SQL

0 Answers   Infosys,

---

When would you use it?

0 Answers  

---

What is use of dbcc commands?

0 Answers  

---

---

what is differece between union and union all

6 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

Explain stored procedure?

0 Answers  

---

How to invoke a trigger on demand?

0 Answers  

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

---

Are connections to sql server encrypted?

0 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---