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 an execution plan?

569


SQL Server Architecture ?

1936


Explain DBCC?

570


How to make remote connection in database?

599


What are the features of Embedded SQL

674






If user is owning any SQL Objects, can we drop that user

1607


What do you understand by a stored procedure?

605


What is mapping schema?

584


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

544


Can coalesce return null?

547


What is the difference between locking and multi-versioning?

538


Describe in brief sql server monitoring ways.

589


Does view occupy space?

518


What do we have to check in database testing?

585


How to write an inner join with the where clause in ms sql server?

557