SQL VIEW with examples..

SQL VIews are generally used to make querying data easier.

show here more details
http://www.experts-exchange.com/Database/MySQL/Q_23954833.html

will get here Example
http://www.w3schools.com/SQl/sql_view.asp

LP MER

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

Hi Gopal,

View is called as Temp Table (or) Virtual Table.Its get a data from one (or) more table. we create view for one table means if any insert (or) update the view means its also affect the original table.
Main use of view is just create a query for using different table and get the values from that table.But performance wise its very slow to execute.

Get More idea refer those links...

http://www.codeproject.com/KB/database/View.aspx

http://www.c-sharpcorner.com/UploadFile/skumaar_mca/viewsinsqlserver200510132009103348AM/viewsinsqlserver2005.aspx

Cheers :)

Thanks,
T.Saravanan

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

Hi

1. View is a Virtual table. Not a Temporary, Physical table.
2. View is used to Encapsulate/protect some importent/sensitive column data.

i.e:
- You might have faced some situation in your company like... You don't have direct rights to access the actual physical Table... Instead you only have access the View instaed. The meaning is , They have protected/encapsulated some importent/sensitive column.
So, you can only access the columns of a table which they have provided inside the View, But you can not access all the columns from the Table.

- Performing Insert, Update & Delete is not recommended using View. The view is recommended for Read operation, Not for write operation, In that case, you have to use Stored Procedure, But you can not see the actual procedures' script like what they have used inside the procedure , The actual procedure will also be Encrypted. This is also one of Encapsulation of hiding Business rules/sensitive column.

- You will not have rights to View the definition of the Stored Procedures /View and don't have direct access to the physical table.

- Some authorized person only have Sysadmin rights....

Please refer for deep drive into View...
http://msdn.microsoft.com/en-us/library/ms187956.aspx

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

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

1) VIEW IS AN VIRTUAL TABLE
2) VIEW ITS OCCUPY ANY MEMORY SPACE
3) CANNOT INSERT ,UPDATE,DELETE IN VIEW.
4) SECURITY PURPOSE TO USE VIEW.
5) VIEW IS A TEMPORARY TABLE.
6) VIEW HAS NO DIRECT ACCESS TO THE PHYSICAL TABLE.


REGARDS
SRIRAM.R

sriram

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

Hi @Sriram....

The 3rd point you have mentioned, I think we can INSERT ,UPDATE,DELETE IN A VIEW !
Can you just clarify a bit !


Thanks and Regards
Akiii

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

@CGN007.....thanks !


Regards
Akiii

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

Refer this link

http://www.w3schools.com/sql/sql_view.asp ]
http://www.techonthenet.com/sql/views.php

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

Please refer this link too
http://msdn.microsoft.com/en-us/library/aa214068%28v=sql.80%29.aspx
http://msdn.microsoft.com/en-us/library/ms187956.aspx

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

Hi @CGN007.....This is not my post. This is gopal's post, only he can mark as an answer !


Regards
Akiii

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

CREATE VIEW View_Name

 AS

SELECT * FROM Table_name

WHERE condition

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

hi.. Look at this link.
http://www.codeproject.com/Articles/266985/Views-In-SQL-Server

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

Hi. @Gopal_nivas
Mark As Answer, if above post helps u.

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