| Author: soniumesh 04 Nov 2009 | Member Level: Gold | Rating:  Points: 2 |
Hi,
Try some googling and you will be get a batter ans and result.
Regard,
umesh soni
|
| Author: Anil Kumar Pandey 04 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
to provide only a certain columns for display to user like if you want to display only name and address not salary then we can create the View to be display for the user..
Thanks & Regards
Anil Kumar Pandey
|
| Author: Shunmuganathan M 04 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
1. We can go for table when we want to store the permanant data
2. We can go for views when we want to store the temp data
By Nathan
Direction is important than speed
I am following the following Health Tips
http://dotnetspider.com/sites/1048/-Health-Tips-for-Healthy-Wealthy-IT.aspx
|
| Author: Melchior 04 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
Table :- It has Rows and columns.It is the basic storage unit
A VIEW is only a mirror image of table which is used at places where large access to a table is required.Views cannot be updated deleted and modified but we could select data from views easily.Views are created to hide some columns from the user for security reasons and to hide information exist in the column.
|
| Author: Neetu 04 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Melchior told you the difference but there is one more that is table required physical space to store the data whereas view doesnot require physical space.
regards
Neetu
|
| Author: Humble 04 Nov 2009 | Member Level: Bronze | Rating: Points: 2 |
Hi,
As u told views cannot be updated and deleted, i checked it we can update and delete views.....
|
| Author: Manvinder Kaur 07 Nov 2009 | Member Level: Bronze | Rating: Points: 2 |
In some databases we can update as well as delete a view but in some databases we cant not update Views....
|
| Author: sriram 23 Nov 2009 | Member Level: Bronze | Rating: Points: 2 |
View is an Virtual Table.. View is an Imaginery Table..
throuh View u can able to insert ,Update ,Delete Records.
u got better performace u r using views in your application.
better security u can use view
1) schemabinding.
2) Encryption.
Table:
colleciton on information put a order . it will store Row and column Wise
Sriramramaswamy
|