What are the advantages of using views. Why do we need
views when we have SPs?
- 4 Answers
- 15683 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / jk.garg25
Views can be update, delete or insert
| Is This Answer Correct ? | 8 Yes | 11 No |
Post New Answer View All Answers
What are scalar functions?
What are the differences between user defined functions and stored procedures?
What is clustered vs nonclustered index?
What does Master database contains?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is data compression? : sql server database administration
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Define union, union all, minus, intersect?
Which tools are available to manage SQL Azure databases and servers?
What is msdb database? : SQL Server Architecture
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are system databases into sql server (2005/2008) : sql server database administration
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Explain the properties of the relational tables?
what are the new features in SSRS?
