Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using views. Why do we need
views when we have SPs?
- 4 Answers
- 16558 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / reddy
1) we can use views in sp instead of joins to increase the
performance of SP.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is a mixed extent?
What is indexing and its types?
What is exclusive locks?
How to count duplicated values in a column in ms sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Explain few of the new features of sql server 2008 management studio
How to send a ssrs report from ssis?
What is clustered vs nonclustered index?
 Explain what is sql override for a source taLle in a mapping?
What stored by the master?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is onf in normalization form?
What is the difference between insensitive and scroll cursor?
Which autogrowth database setting is good?
What is indexing explain it with an example?
