Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 22550 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
What are rows and columns?
How do I view a trc file?
what is database replicaion? : Sql server database administration
What is CTE in SQL
Write a program to fetch first 10 records from a file?
what are the different types of replication you can set up in sql server? : Sql server database administration
What are “lost updates”?
Please illustrate physical database architecture? : SQL Server Architecture
How to rebuild all indexes on a single table?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is acid properties?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is mean by dml?
Why use sub query in sql server and list out types of sub queries?
How to get a list all databases on the sql server?
