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
What do you mean by SQL injection attack?
What is the purpose of optimization?
What is the server name for sql management studio?
Explain index in sql server?
What are “unrepeatable reads”?
What are the types of user defined functions in sql server?
How to modify an existing user defined function?
what is database replication? : Sql server database administration
What is a full text index?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Can you explain what is the use of custom fields in report?
Differentiate between a having clause and a where clause.
How do clustered indexes store data?
Ways to improve the performance of a SQL Azure Database?
What do you understand by integration services in sql server?