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
What is difference between global temporary tables and local temporary tables?
Explain what is lock escalation?
What is tcl in sql server?
What is serializable?
What is log shipping?
How does Report Builder support Analysis Services cubes?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is a rollup clause?
What are the disadvantages of primary key and foreign key in SQL?
Is null vs coalesce?
How to get the definition of a stored procedure back?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How to use group functions in the select clause in ms sql server?
Explain few examples of RDBMS?
