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
Explain where clause?
How to view existing indexes on an given table using sp_help?
Why it is recommended to avoid referencing a floating point column in the where clause?
How to convert a table data in XML format in sql server?
Explain something about security and SQL Azure?
What do you understand by replication in sql server?
SQL Server Architecture ?
How to create nested stored procedure?
what happens on checkpoint? : Sql server database administration
What languages bi uses to achieve the goal?
How will you monitor replication latency in transactional replication? : sql server replication
what is a live lock? : Sql server database administration
What are basics of policy management?
What are the different authentication modes in sql server?
What is constraints and its types?