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

What is #temp and @table variable in SQL server?

1024

What happens if the update subquery returns no rows in ms sql server?

1072

Tell me something about security and sql azure?

114

Is it possible to create trigger on views?

932

What is parameterized reports in ssrs ?

140

What is BCNF? How is it better than 2NF & 3NF?

963

How to modify existing triggers using "alter trigger"?

933

What are a database and a data warehouse?

968

Explain following error properties?

954

How to create nested stored procedure?

946

How you trouble shoot when any job fails

1894

Why do we need different type of parameter?

997

Can we install sql server 2016 on windows 7?

1071

How to stop a loop early with break statements in ms sql server?

972

What is faster join or union?

1106