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

What is the openxml statement in sql server?

1049

---

Differentiate between sql temp table vs table variable?

862

---

Can primary key be null?

913

---

What is exclusive locks?

940

---

What is indexing a document?

1020

---

What do mean by xml datatype?

1065

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

---

How do I view views in sql server?

985

---

What is meant by datasource?

903

---

What is the difference between stored procedure and user defined functions?

1174

---

What is a linked server in sql server?

1053

---

what are defaults? : Sql server database administration

1069

---

How to find table changes in sql server?

1095

---

What is cdc in sql server?

983

---

what are acid properties? : Sql server database administration

975

---