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 datawarehouse?
What happens if null values are involved in bitwise operations?
Explain a checkpoint?
What are security principals used in sql server 2005?
What is a ddl statement?
how to take backup bcp out for a column in table in sql server?
How many replicas are maintained for each SQL Azure database?
What is blocking and how would you troubleshoot it? : sql server database administration
Can we join two tables without primary key?
What is query processing?
Can a trigger be created on a view?
what authentication modes does sql server support? : Sql server database administration
What is the native system stored procedure to execute a command against all databases?
what is the difference between openrowset and openquery?
What is self join in sql server joins?