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 / veena

Views can reduce the complexity of database schema
Veiw can provide column level and row level security
By using views present aggregated data and hide detailed data

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the different types of triggers?

1200


What are the different types of collation sensitivity in sql server?

1162


Why use stored procedures in sql server?

1057


Your table has a large character field there are queries that use this field in their search clause what should you do?

923


Do you know what are pages and extents? : SQL Server Architecture

1035


Why we use functions in sql server?

1127


Name the different type of indexes in sql?

1012


Can the query output be sorted by multiple columns in ms sql server?

1028


What is raid, and how it can influence database performance?

1097


Explain what is row_number function?

1081


Explain the Ways to improve the performance of a sql azure database?

84


What stored by the master?

1010


How can sql injection be stopped? : sql server security

1100


List out what other servers you can use with ssrs?

145


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

997