Why views in sql server 2005

Complex queries can be stored in the form as a view, and data from the view can be extracted using simple queries. Because views are stored as part of the database, they can be managed independently of the applications that use them. A view behaves like a virtual table. Since you can code a view name anywhere you can code a table name.

Views can be used to restrict the data that a user is allowed to access or to present data in a form that is easy for the user to understand. In some database users may be allowed to access data only through views. In this example, I am using my Vendor database which has these fields.

Here is my database: Figure 1. To use the stored procedure you send a request for it to be executed. When server receives the request, it executes the stored procedure. Stored procedures assist in achieving a consistent implementation of logic across applications. The SQL statements and logic needed to perform a commonly performed task can be designed, coded, and tested once in a stored procedure. Each application needing to perform that task can then simply execute the stored procedure.

Coding business logic into a single stored procedure also offers a single point of control for ensuring that business rules are correctly enforced. Stored procedures can also improve performance. Many tasks are implemented as a series of SQL statements. You index a view by creating a unique clustered index on it.

Indexed views can dramatically improve the performance of some types of queries. Indexed views work best for queries that aggregate many rows. They are not well-suited for underlying data sets that are frequently updated. Partitioned Views A partitioned view joins horizontally partitioned data from a set of member tables across one or more servers. This makes the data appear as if from one table. A view that joins member tables on the same instance of SQL Server is a local partitioned view.

System Views System views expose catalog metadata. You can use system views to return information about the instance of SQL Server or the objects defined in the instance. For example, you can query the sys.

Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Skip to main content.

Acceptable Use Policy. Advertiser Disclosure:. SQL Etc. Database Forum. Rss Feed. MS Access. Free Newsletters: Email subscribe. Advertiser Disclosure. August 17th, AM.

Need help changing table contents. SQL Server Memory confifuration. August 14th, AM. July 25th, AM.