Answer Posted / suraj
-- Views are updatable regardless of the number of
tables involved in that view.
-- Data contained in the base tables are updated when
VIEWS are updated.
drop table t1
drop table t2
drop view t1t2
create table t1(ID int, FirstName varchar(20))
create table t2(ID int, LastName varchar(20))
insert t1 values(1,'John')
insert t1 values(2,'Mike')
insert t2 values(1,'Smith')
insert t2 values(2,'Shres')
create view t1t2
as
select t1.FirstName, t2.LastName
from t1 inner join t2 on t1.ID=t2.ID
update t1t2
set FirstName='Steve' where LastName='Smith'
select * from t1t2
select * from t1
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
How to provide values to user defined function parameters?
How do I make a resultset scrollable?
What are constraints in microsoft sql server?
Difference between Sql server reporting services and Crystal reports?
Explain the steps to use transact-sql cursor?
What do you mean by an execution plan? How would you view it?
What is not null constraint?
Create and insert into temp table in sql server?
What xml support does the sql server extend?
What type of locking occurs during the snapshot generation? : sql server replication
What are the acid properties?
How to recompile stored procedure at run time?
Should you normalize audio?
What do you know about normalization and de- normalization?
How to create an index on a view?
