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.

Explain identity in sql server?

1016

---

What is data source view or dsv? : sql server analysis services, ssas

1007

---

Explain about system stored procedure?

1038

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

957

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1043

---

What is a unique key constraint?

1032

---

What are the types of database schema? : sql server analysis services, ssas

1137

---

Can you edit the .rdl code associated with a linked report?

164

---

How can change procedure in sql server?

1073

---

Explain about local stored procedure?

976

---

How to make a column nullable?

1124

---

How do I start and stop sql server?

1029

---

Explain about Joins?

997

---

What is in place upgrade in sql server?

1047

---

What are approximate numeric data types in ms sql server?

1065

---