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 difference between equi join and natural join?
How do you delete duplicate rows in sql server?
Explain comment on transactions?
What is dynamic cursor in SQL SERVER?
What is an example of a primary key?
How to call stored procedure using http soap?
What are the differences between clustered and non-clustered index?
What are the different types of backups that exist?
What is tablesample?
What is difference between group by and having?
How optimize sql query with multiple joins in sql server?
What is sql server profiler?
How to encrypt Strored Procedure in SQL SERVER?
What is the current limitation of the size of SQL Azure DB?
What is 5nf in normalization form?