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
- 16559 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / dr.job418
A view provides several benefits.
1. Views can hide complexity
If you have a query that requires joining several tables, or has complex logic or calculations, you can code all that logic into a view, then select from the view just like you would a table.
2. Views can be used as a security mechanism
A view can select certain columns and/or rows from a table, and permissions set on the view instead of the underlying tables. This allows surfacing only the data that a user needs to see.
3. Views can simplify supporting legacy code
If you need to refactor a table that would break a lot of code, you can replace the table with a view of the same name. The view provides the exact same schema as the original table, while the actual schema has changed. This keeps the legacy code that references the table from breaking, allowing you to change the legacy code at your leisure.
These are just some of the many examples of how views can be useful.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is difference between getdate and sysdatetime in sql server 2008?
Define outer join?
How to set database to be read_only in ms sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is merge?
What is the usage of the sign function?
How to create sub reports?
What the different types of Replication and why are they used?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is use of except clause? How does it differ from not in clause?
What is an indexed view?
What is inline variable assignment?
How do I find the sql server instance name?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
