Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 22025 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mehtab ullah
Purpose of view
Views hide data complexity.
Views add security by restricting access to the columns of a
table.
Views simplify the complex queries for the user.
View is a way to isolate application from changes in
definitions of base tables.
View is derived from the perant table.
View do not occupy any space in the memory .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about SQLOS?
What are ddl triggers and types of ddl trigger?
List out the difference between union and union all in sql server?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are the properties of the relational tables?
What are the ways available in sql server to execute sql statements?
Why normalization is used?
Do you know the isolation level that sql server support?
What is a scheduled job or what is a scheduled task?
What are data driven subscriptions?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How to Insert multiple rows with a single insert statement?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Explain the rules for designing files and file groups in sql server?
What are the differences between having and where clause.
