Why de-normalization required?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

What is a primary index?

0 Answers  

---

How can you append an identity column to a temporary table?

0 Answers  

---

---

Explain triggers in sql?

0 Answers  

---

What are constraints?

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

What is the sql case statement used for? Explain with an example?

0 Answers  

---

How are the unique and primary key constraints different?

0 Answers  

---

What are user-defined functions (udfs) in sql server?

0 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

---