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 is meant by Active-Passive and Active-Active clustering setup?
How to list all schemas in a database?
How to recover from sql injection? : sql server security
What are the benefits and tasks of object explorer? : sql server management studio
What command must you use to include the not null constraint after a table has already been created?
How to check if stored procedure is running in sql server?
Explain the phases a transaction has to undergo?
what is procedure in sql?
what are candidate key, alternate key and composite key? : Sql server database administration
What are translations and its use? : sql server analysis services, ssas
Difference between server.transfer and server.execute method?
Call by value and call by reference in procedure and function, with NOCOPY.
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)