what is the purpose of creating view is sql server 2000
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anil sharma
Views are dynamic table that is it created at run time and
not stored on server database.
by using view we can solve typical query.
| Is This Answer Correct ? | 1 Yes | 4 No |
What are scalar functions in sql?
Simple example for difference between select and cursor in sql
how to select a field with firstletter as capital and remaining are small letters
Explain sub-query?
How do you set a trace flag in sql server?
How do I start sql server agent automatically?
What is data modification?
How many types of triggers are there?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What does REVERT do in SQL Server 2005?
What are the types of processing and explain each? : sql server analysis services, ssas
How does index makes search faster?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)