Interested to Buy Any Domain ? << Click Here >> for more details...
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 loop through the result set with @@fetch_status?
What is statement level trigger?
Explain nested join?
What is a transact-sql statement batch in ms sql server?
What is cursor in ms sql server?
What are the restraints imposed on the table design by a merge replication?
Explain trigger and its types?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What are data files?
Can a function call a stored procedure in sql server?
What is query processing?
what stored procedure can you use to display the current processes? : Sql server administration
What are the different types of replication you can set up in sql server?
What is a view and what are its advantages?
what are the different stages of Report Processing?
