what is the purpose of creating view is sql server 2000
Answer Posted / nithya.r
A view is a virtual table. A view serves as a security
mechanism. If we have several tables in a database and we
want to view only specific columns from specific tables we
can go for views. Using view we can avoid the complex
queries.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
what is blocking? : Sql server database administration
How to write character string constants or literals in ms sql server?
What is clustered primary key?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Why truncate is ddl command?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is an etl file?
Describe and explain about SQL native client?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is mean by candidate key?
When you use @@error and try-catch?
what are different types of raid configurations? : Sql server database administration
How do I create a stored procedure in sql server?
What is transactional replication?
What is sub query and its properties?