What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

Explain what is dbcc?

0 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---

How to invoke a trigger on demand?

0 Answers  

---

Explain activity monitors

0 Answers  

---

---

Explain steps of normalization?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

How do I get to sql server configuration manager?

0 Answers  

---

What is a materialized view?

3 Answers  

---

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

What you can do to delete a table without the delete trigger firing?

0 Answers  

---