Views in SQL Server...

Posted by Muhsinathk under Sql Server on 6/13/2012 | Points: 10 | Views : 2284 | Status : [Member] | Replies : 9
Hi,
I want to know more about view?
Is there any good link?




Responses

Posted by: Muhsinathk on: 6/13/2012 [Member] Bronze | Points: 25

Up
0
Down
Thank you

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 6/21/2012 [Member] Starter | Points: 25

Up
0
Down
view :

1) view is an virtual Table.
2) View it wont occupy any memory space.
3) View is an Temporary table.
4) To increase the performance to use view.
5) View has two methods available.
1) schema binding
2) Encryption

create view <view_name>
as

select * from <table_Name>

regards

Sriram.R





sriram

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Weblorquins on: 7/16/2012 [Member] Starter | Points: 25

Up
0
Down

A view can be thought of as a stored query accessible as a virtual table. It can be used for retrieving data as well as updating or deleting rows. Views in SQL Server provide a preset way to view data from one or more tables. They may also include aggregate fields (e.g., COUNT, SUM). Views allow your users to query a single object which behaves like a table and contains the needed joins and fields you have specified. In this way, a simple query (SELECT * FROM ViewName) can produce a more refined result which can serve as a report and answer business questions.

Rows updated or deleted in the view are updated or deleted in the table the view was created with. It should also be noted that as data in the original table changes, so does the data in the view-as views are the way to look at parts of the original table. The results of using a view are not permanently stored in the database. The data accessed through a view is actually constructed using a standard T-SQL select command and can come from one to many different base tables or even other views.

Two main purposes of creating a view are
1.) provide a security mechanism which restricts users to a certain subset of data
2.)provide a mechanism for developers to customize how users can logically view the data.

More about interview Question Click below link

http://sqlserver4us.blogspot.in/


Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 7/16/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
look at this url

http://www.codeproject.com/Articles/38560/Overview-of-View-in-SQL-Server-2005



Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 7/18/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

check this link

http://msdn.microsoft.com/en-us/library/ms187956.aspx

http://msdn.microsoft.com/en-us/library/hh231699.aspx

R D Patel

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 7/18/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

some more and nice links

http://odetocode.com/code/299.aspx

http://www.c-sharpcorner.com/UploadFile/6cde20/concept-of-view-in-sql-server/

R D Patel

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 7/18/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
check this
http://www.sqlinfo.net/sqlserver/sql_server_VIEWS_the_basics.php

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Arul44ece on: 7/19/2012 [Member] Starter | Points: 25

Up
0
Down
Hi ,,

Please go through the below link.

http://www.codeproject.com/Articles/38560/Overview-of-View-in-SQL-Server-2005

Regards,

Arul R
arul44.ece@gmail.com

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 7/20/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
Look at this link

http://www.codeproject.com/Articles/266985/Views-In-SQL-Server

.

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response