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
- 16566 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 are the components of sql server service broker?
What do you understand by check constraint in sql server?
Can two tables share the same primary key?
How does using a separate hard drive for several database objects improves performance right away?
What are sql server functions?
What is the size of transaction log file?
Can you leave a union at any time?
What is the difference between delete and truncate statements?
Explain atomicity?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Differentiate between mongodb vs. Sql server?
How to use "begin ... End" statement structures in ms sql server?
What is pessimistic concurrency?
What is 4nf in normalization form?
How can I check that whether automatic statistic update is enabled or not?
