what is the purpose of creating view is sql server 2000

Answer Posted / sundaresan

Views are used to select particular columns from a table
which is residing in a different DB. Once views are
crerated we can access the view to get the specified column
details from the table which is present in a different DB

Is This Answer Correct ?    14 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SubQuery in SQL Server 2008

639


When would you use sql joins?

607


What is the log shipping?

670


What is the difference function and stored procedure?

636


What are locks in sql?

618






Why truncate is ddl command?

612


How to add more data to the testing table in ms sql server?

643


What is SQL Azure Federations?

106


What is a rownum?

588


what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

620


Do you know concepts and capabilities of sql server?

671


How to verify a user name with sqlcmd tool?

692


What is key attribute?

607


How can you append an identity column to a temporary table?

523


What are the different types of locks in the database?

559