View is used to fetches the data from existing table and it doesn't

what is the purpose of creating view is sql server 2000

Question Posted / thirumal

Answer Posted / thirumal

View is used to fetches the data from existing table and it
doesn't occupy any space in memory.

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Which are the two editions in which SQL Azure database available?

119

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1032

Write a sql query to delete duplicate records from a table called table1

1023

Please explain go command in sql server?

1042

What is partition in sql server?

1031

How do I manually uninstall an instance of sql server 2016?

1025

What is resource governor in sql server?

986

What is explicit cursors?

1061

What is the purpose of linked server configuration in sql server?

1036

How can you control the amount of free space in your index pages?

1052

What is the difference between an index and a unique index?

994

How you can get the list of largest tables in a database?

1005

Explain the xml support sql server extends?

1032

What do you understand by replication in sql server?

1055

What are the purposes of floor and sign functions?

964