Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 21593 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kumar.t
1. View is logical representation of the table.
2. View is derived from the table.
3. view don't occupy any memory space.
purpose.
1. Security
2. Simplicity of the query.
Another Important Point : view is updatble.
By
Kumar.T
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
How to list all user names in a database?
How is a full-text index updated?
How does a profiler work?
Can we write trigger for view?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is sql stored procedure?
Explain the benefits of user-defined functions?
How do I partition a table in sql server?
Can you please explain the difference between primary keys and foreign keys?
What are the different kinds of ssrs reports?
What is the maximum number of index per table?
Can a synonym name of a table be used instead of a table name in a select statement?
How to choose all records from the table?
Why can there be only one clustered index and not more than one?
What is sql server transaction log file?
