Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 21608 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Explain subquery and state its properties?
Which is the latest version of sql server and when it is released?
Write the syntax for stuff function in an sql server?
What is 5nf in normalization form?
How are the unique and primary key constraints different?
What is the Main Difference between ACCESS and SQL SERVER?
What is the use of DBCC commands?
What is standby servers? Explain types of standby servers.
What is de-normalization and when do you do it?
What factors you will consider calculating the storage requirement for that view?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
How to define the name and server for a new dsn?
-
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)
