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
Can group functions be mixed with non-group selection fields in ms sql server?
Why is the need for data conversion transformations?
What is the purpose of object explorer and its features? : sql server management studio
What is an sql server agent?
In what version of sql server were synonyms released?
Explain what is row_number function?
Give an example of why you would want to denormalize a database
What are some examples of schemas?
What is mean by candidate key?
How to replace null values in expressions using isnull()?
What is data modification?
How to drop existing indexes in ms sql server?
What is it’s similarity with sql server?
How ssrs maintain security?
What is shared lock?