What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

Explain having clause?

0 Answers  

---

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

List down some advantages of sql stored procedure?

0 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

How many non clustered indexes there can be on table ?

0 Answers  

---