Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the purpose of creating view is sql server 2000

Answer Posted / nithya.r

A view is a virtual table. A view serves as a security
mechanism. If we have several tables in a database and we
want to view only specific columns from specific tables we
can go for views. Using view we can avoid the complex
queries.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is datawarehouse?

1154


What happens if null values are involved in bitwise operations?

1077


Explain a checkpoint?

1085


What are security principals used in sql server 2005?

1036


What is a ddl statement?

960


how to take backup bcp out for a column in table in sql server?

2141


How many replicas are maintained for each SQL Azure database?

144


What is blocking and how would you troubleshoot it? : sql server database administration

1093


Can we join two tables without primary key?

1092


What is query processing?

988


Can a trigger be created on a view?

992


what authentication modes does sql server support? : Sql server database administration

1182


What is the native system stored procedure to execute a command against all databases?

1085


what is the difference between openrowset and openquery?

1155


What is self join in sql server joins?

1115