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 a field name?
Explain candidate key, alternate key, and composite key?
How to change the data type of an existing column with "alter table" statements in ms sql server?
List all types of constraints in sql server?
What are clustered and non-clustered index?
Explain raiserror in sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
How do I clean up sql server transaction log?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What are a database and a data warehouse?
What is a trigger? Why we need it?
where the connection string store in the database
What's new in sql management studio for sql server? : sql server management studio
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is the distinction amongst delete and truncate?