Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 22208 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 the difference between functions and stored procedures?
Is INSTEAD OF trigger directly applicable to Table ?
Explain ms sql server reporting services vs crystal reports?
What is database architecture? : SQL Server Architecture
write query for fourth maximum salary from employee table
14 Answers Mind Tree, SP Software,
What is the difference between views and stored procedures? Can we have input parameters for views?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What number sorts of privileges are accessible in sql?
Explain having clause?
What do you understand by recursive stored procedures?
How to find index size for each index on table?
What are the new data types are introduced in sql 2000?
-
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)
