Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS SQL Views advantages/disadvantages

Posted on 2005-03-21
4
Medium Priority
?
1,477 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
  • 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

580 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