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.

What is read uncmmited?

1058

---

What is data compression? : sql server database administration

968

---

can SSRS reports Cache results?

147

---

Define tool Manage Statistics in SQL Server 2000 query ?

1093

---

How to replace given values with null using nullif()?

987

---

what are the reporting service components in SSRS?

163

---

between cast and convert which function would you prefer and why?

954

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1053

---

What is policy management?

996

---

How to get the definition of a user defined function back?

1044

---

What is attribute hierarchy? : sql server analysis services, ssas

1018

---

How does using a separate hard drive for several database objects improves performance right away?

932

---

Explain sql server authentication modes?

1127

---

What is function of CUBE ?

1045

---

Where in ms sql server is ’100’ equal to ‘0’?

1087

---