what is the purpose of creating view is sql server 2000
Some times we need to use the same query repeatedly for a large number of times.So instead of writing the same query all the times we use views. Means we store the query with a name that name is called as a view.