what is the purpose of creating view is sql server 2000
- 13 Answers
- 19349 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 verify the port number of the sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is rtm version in sql server?
What is the difference between set and select?
Do you know what is blocking?
what is blocking? : Sql server database administration
How to Sync Two SQL Azure Databases?
Explain the different index configurations a table can have?
What is clustered index
How many replicas are maintained for each sql azure db?
What are parameterized reports? What are cascading parameters in ssrs reports?
what is sql server? : Sql server database administration
What are the built in functions in sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is a mutating table error and how can you get around it?
