?
Solved

MS SQL Views advantages/disadvantages

Posted on 2005-03-21
4
Medium Priority
?
1,470 Views
Last Modified: 2010-07-27
What is the VIEWS in MS SQL DB for ?

What benefits does it do for my application if my application is report intensive ?

thank you for all experts advices

Any site for good readings and also learn VIEWS ?

cheers and regards
wee
0
Comment
Question by:weeee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
4 Comments
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 13589555
0
 
LVL 14

Accepted Solution

by:
Thandava Vallepalli earned 1000 total points
ID: 13589578
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 13589630
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 13589652
Views
A view is a virtual table whose contents are defined by a query. Like a real table, a view consists of a set of named columns and rows of data. However, a view does not exist as a stored set of data values in a database. The rows and columns of data come from tables referenced in the query defining the view and are produced dynamically when the view is referenced.

A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases. Distributed queries can also be used to define views that use data from multiple heterogeneous sources. This is useful, for example, if you want to combine similarly structured data from different servers each of which stores data for a different region of your organization.

There are no restrictions on querying through views and few restrictions on modifying data through them.

This illustration shows a view based on two tables.

http://msdn.microsoft.com/library/en-us/createdb/fund02.gif



itsvtk

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_06_6ypj.asp

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question