adspace


what is the purpose of creating view is sql server 2000

Answer Posted / reddi

to hide some confidential information

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is acid mean in sql server?

1247


Does view occupy space?

1021


List the ways in which dynamic sql can be executed?

1087


what is the difference between openrowset and openquery?

1197


Where can you add custom error messages to sql server?

1214


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1215


How raid can influence database performance?

1118


Can you index views?

955


How can I check that whether automatic statistic update is enabled or not?

1113


What are the kinds of subquery?

1109


What is an indexed view?

1023


What are the different SQL Server Versions you have worked on?

1080


What is self contained sub query?

1141


Why and when do stored procedure recompile?

1064


What are the properties of the transaction?

1074