Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 21633 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 |
What is a group function explain with an example?
What are distinctive joins find as a part of sql?
Explain different types of Normalization.
1 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
What are joins in sql and what are the different types of joins?
What is sql server schema compare? How we can compare two database schemas?
Describe in brief authentication modes in sql server.
What does the on update no action do?
What is the difference between DTS and SSIS?
from the table display the 2nd highest salary? and also the least 2nd salay?
How to use “drop” keyword in sql server and give an example?
What is difference between foreign key and unique key?
How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
-
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)
