what is the purpose of creating view is sql server 2000
Answer Posted / 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 |
Post New Answer View All Answers
How to configure and test odbc dsn settings?
What is log cache in sql server?
What are sub reports and how to create them?
What is the use of tempdb? What values does it hold?
Do you know what is fill factor and pad index?
What happens when the SQL Azure database reaches Max Size?
Explain four layers of abstraction microsoft architectured?
Can you use order by when defining a view?
What is dknf in normalization form?
How can you insert null values in a column while inserting the data?
What is rtm version in sql server?
What are the disadvantages of indexes?
What do you understand by user-defined function in the sql server?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How to enable tcp/ip protocol on a sql server?