Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 22158 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
Can a unique index be created on a column, which contains null?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain about analysis services?
Is it possible to call a stored procedure within a stored procedure?
What is 'Join' and explain its various types.
What is index fragmentation in ms sql server?
Explain primary key, foreign key and unique key?
What is inline variable assignment?
What is a not null constraint?
Explain what role entity and relationship play in an ER diagram.
What Is Rdbms?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is the difference between a local and a global temporary table?
What is report rendering ?
What are the types of subquery?
