what is the purpose of creating view is sql server 2000

Answers were Sorted based on User's Feedback



what is the purpose of creating view is sql server 2000..

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

what is the purpose of creating view is sql server 2000..

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 purpose of creating view is sql server 2000..

Answer / raju

in sql was operation doing DML,DCl querey.

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More SQL Server Interview Questions

What is the difference between the application object and session object?

0 Answers  


What are explicit and implicit transactions?

4 Answers   BirlaSoft,


what is Equity join?

2 Answers   ADP,


What types of integrity are enforced by a foreign-key constraint

1 Answers  


What is compression - row-level and page-level compression?

0 Answers  






Find first and last day of current month in sql server

0 Answers  


How do I view a trc file?

0 Answers  


How to configure odbc dsn with different port numbers?

0 Answers  


What is bcp? When does it use?

0 Answers  


What is de-normalization in sql database administration? Give examples?

0 Answers  


1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,


How to download and install microsoft sql server management studio express?

0 Answers  


Categories