what is the purpose of creating view is sql server 2000

Answer Posted / vijayabhaskarreddy

view eassy to use , views used to work with part of the
tables.
** provides security for the data.

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scan table/view and seek table/view when its occurs? : sql server database administration

608


Which tcp/ip port does the sql server run on? How can it be changed?

632


How to loop through returning rows?

658


Can you explain what are various ways to enhance the ssrs report?

668


How to generate random numbers with the rand() function in ms sql server?

666






Explain few examples of stored procedure over triggers?

620


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

614


What is sparse columns of sql server 2008?

692


What is federation member?

103


Can sql server be linked with other servers like oracle?

608


What is data block and how to define data block size?

692


What does sql server mean?

612


What is the difference between DataRow.Delete() and DataRow.Remove()?

837


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

627


How will you monitor replication latency in transactional replication? : sql server replication

704