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 difference between stored procedure and functions?

774

---

How to add additional conditions in SQL?

767

---

Explain few of the new features of sql server 2008 management studio

685

---

What is dimension table? : sql server analysis services, ssas

747

---

What are the types of joins in sql?

773

---

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

1740

---

What is a cube? : sql server analysis services, ssas

715

---

What is a recursive stored procedure in sql server?

772

---

How do I start sql server 2016?

687

---

What is a document index?

770

---

When is the use of update_statistics command?

736

---

What is system stored procedures?

760

---

Explain few examples of stored procedure over triggers?

690

---

How do I completely remove sql server instance?

776

---

What are truncate options available in sql server? : sql server database administration

743

---