what is the purpose of creating view is sql server 2000
Answer Posted / satyanarayana
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.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What stored by the msdb? : sql server database administration
How to compare the top two records using sql?
What are cursors and when they are useful?
do views contain data ?
How do indexes help, types?
What number aggregate functions are accessible there in sql?
How is a full-text index updated?
What is the exact numeric data type in sql?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
how can u get last observation in an unknown dataset ?
Explain what is the main purpose of having conversation group?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What are user defined functions in ms sql server?
What do you understand by triggers?
How to delete duplicate rows in sql server?