What are the advantages of using views. Why do we need
views when we have SPs?
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 happens if the update subquery returns no rows in ms sql server?
What is the difference between clustered index and primary key?
What is dbcc updateusage?
What is difference between inner join and join?
Can primary key be null?
How you provide security to cube? : sql server analysis services, ssas
How to find related tables in sql server?
Explain about SQL server 2005?
What is the purpose of sql profiler in sql server? : sql server database administration
How will you optimize a stored procedure optimization?
How can you find out how many rows returned in a cursor?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the syntax for encrypting a column in SQL Server?
What is difference between clustered index and non clustered index?
What is the difference between NOROW and LOCKROW?