List out the difference between union and union all in sql server?

0 Answers  

---

What is Dependency Injection and provide example?

0 Answers  

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Explain partitioned view?

0 Answers  

---

---

What are the properties of the relational tables?

0 Answers  

---

How to remove duplicate rows from table except one?

0 Answers  

---

What is set nocount on?

0 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

What is the difference between system objects and user objects?

0 Answers   HCL,

---