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
How to create an index on an existing table in ms sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
How to receive returning result from a query?
What are the different sql server versions?
What is the security principal at the server level that represents your session?
What are different type of Collation Sensitivity?
what information is maintained within the msdb database? : Sql server administration
Tell me what is de-normalization and what are some of the examples of it?
How to find out the list schema name and table name for the database?
what is the difference between count(*) and count(1) ?
What is policy based management (pbm)? : sql server database administration
Describe how to use the linked server?
What is the difference between join and inner join?
What is 'write-ahead log' in sql server 2000 ?
What are the steps you can take to avoid “deadlocks”?
