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 does dml stand for?
Explain concepts of analysis services?
Can we add an identity column to decimal datatype?
What is the Control Flow in SSIS
What does sql server mean?
How to sort query output in descending order in ms sql server?
UPDATE statement can on a single table or on the multiple table?
What is Query Execution Plan? How does it help optimize or tune a database driven application?
What is ddl and dml commands?
How can we call UDF(User Define Function) using C# code in ASP.net ?
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
Can you explain about buffer cash and log cache in sql server?
Oracle (3253)
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)