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

What is a field name?

967


Explain candidate key, alternate key, and composite key?

1003


How to change the data type of an existing column with "alter table" statements in ms sql server?

982


List all types of constraints in sql server?

1045


What are clustered and non-clustered index?

1009


Explain raiserror in sql server?

1029


What is user-defined functions? What are the types of user-defined functions that can be created?

1034


How do I clean up sql server transaction log?

1066


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1092


What are a database and a data warehouse?

1022


What is a trigger? Why we need it?

996


where the connection string store in the database

2071


What's new in sql management studio for sql server? : sql server management studio

1065


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1048


What is the distinction amongst delete and truncate?

1071