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
If a table does not have a unique index, can a cursor be opened on it?
What are the benefits of normalization?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is the maximum size per database for sql server express?
What happens if the update subquery returns multiple rows in ms sql server?
Explain the difference between functions and stored procedures in sql server?
Explain the collation?
What is indexing explain it with an example?
How do I start sql server?
How to select some specific rows from a table in ms sql server?
How to drop an existing table?
How to test values returned by a subquery with the in operator?
what is hash nonclustered index
What are “unrepeatable reads”?
Tell me what is the order in which the sql query is executed?