Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using views. Why do we need
views when we have SPs?
- 4 Answers
- 16734 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / saurabh
View are the image of table.
advantages:- 1> they hide the details of table from which
they get data.
2> they are working as table and, provide security from
unautherized acccess.
3> they are read only.
4> they update automatically when some changes occurs in
original table
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
What do you mean by recursive stored procedure?
What do you understand by mirroring?
Please explain what is “asynchronous” communication in sql server service broker?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is sql profiler. What are the default templates with it? : sql server database administration
Explain magic tables in sql server?
Does partitioning improve performance sql server?
Is foreign key a primary key?
What is report rendering ?
can any body tell me how to know the password of current user in sql server
Explain different forms of normalization?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What are the differences between decimal and float in ms sql server?
do views contain data ?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
