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 the difference between the application object and session object?
What are explicit and implicit transactions?
what is Equity join?
What types of integrity are enforced by a foreign-key constraint
What is compression - row-level and page-level compression?
Find first and last day of current month in sql server
How do I view a trc file?
How to configure odbc dsn with different port numbers?
What is bcp? When does it use?
What is de-normalization in sql database administration? Give examples?
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
How to download and install microsoft sql server management studio express?