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 a view? is View updatable?

Answer Posted / sandhya

You can modify data by using a view in only one of its base
tables even though a view may be derived from multiple
underlying tables. For example, a view vwNew that is
derived from two tables, table and table2, can be used to
modify either table or table2 in a single statement. A
single data modification statement that affected both the
underlying tables is not permitted

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can group functions be mixed with non-group selection fields in ms sql server?

927


Why is the need for data conversion transformations?

1033


What is the purpose of object explorer and its features? : sql server management studio

1187


What is an sql server agent?

1042


In what version of sql server were synonyms released?

927


Explain what is row_number function?

1005


Give an example of why you would want to denormalize a database

966


What are some examples of schemas?

957


What is mean by candidate key?

991


How to replace null values in expressions using isnull()?

1081


What is data modification?

943


How to drop existing indexes in ms sql server?

1054


What is it’s similarity with sql server?

160


How ssrs maintain security?

1055


What is shared lock?

880