Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

What is normalization and what are the advantages of it?

0 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

What is the function of inner join?

0 Answers  

---

Define master database?

0 Answers  

---

---

What is a mixed extent?

0 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

what is a transaction? : Sql server database administration

0 Answers  

---

What is an example of a foreign key?

0 Answers  

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  

---