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
Is the primary key column of a table an index in ms sql server?
What happens to a trigger with multiple affected rows?
Which are the two editions in which SQL Azure database available?
How do I manually uninstall an instance of sql server 2016?
Why use update_statistics command in sql server?
What is difference between views and stored procedures?
What are triggers? How do you invoke a trigger on demand?
Difference between Logical Page and Physical Page in SSRS.
How to execute the cursor queries with "open" statements?
can we have a nested transaction? : Sql server database administration
How to check if a table is being used in sql server?
Explain the steps to use transact-sql cursor?
Explain what is lock escalation and what is its purpose?
Do you know what are various aggregate functions that are available?
How to copy the tables, schema and views from one sql server to another?