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

Is truncate autocommit?

925

What is dynamic cursor in SQL SERVER?

1056

How to how to convert numeric expression data types using the convert() function??

1033

How to list all stored procedures in the current database using ms sql server?

1111

Mention a few common trace flags used with sql server?

916

What is create command?

960

What are the advantages to use stored procedures?

1083

What is trigger explain with program?

964

What are the types of processing and explain each? : sql server analysis services, ssas

1135

Write a program to fetch first 10 records from a file?

988

How adventureworkslt tables are related?

912

What is difference between count (*) and count 1?

913

What is instead of dml trigger?

978

How do I connect to sql server database?

997

Differentiate between SQL and ORACLE joins and write their syntax.

1014