Answer / haritha

we can not update a view which is created from two
tables.But we can update a view which is created from one
table.

Answer / monika

yes,u can update by using instead of triggers.

Answer / arup ratan banerjee

U can update non-updatable views to updatable ones by means
of Instead Of Triggers

Answer / brajesh

yes,but only of those column from which table primary key
is preserved in view

Answer / usha

UPDATE PRODUCT SET UNITPRICE=UNITPRICE+(UNITPRICE*0.2)WHERE
CATEGORIES.CATEGORYNAME=PRODUCT.CATEGORYID;

Answer / raj

folks, I check in practically that View (consist of more
then one table) can update and it impact at Base Table also.
(you can also check from your own self...)
but I data cannot delete from view.

Answer / pavan

by using instead of trigger

Answer / sankar

It is not possible to update a view which is created from
two tables.Actually when we update any viewtha first the
view has been updated followed by the base table.If we use
instead of trigger then the base be table will updated
first not the view.Because the view is stored in database
as a query.Once the base table will be changed,the view
query will hit the base table and reflects the changes.But
I think that's not the desired answer.

Answer / duong

Views in all versions of SQL Server are updatable (can be the target of UPDATE, DELETE, or INSERT statements), as long as the modification affects only one of the base tables referenced by the view, for example:

-- Increase the prices for publisher '0736' by 10%.
UPDATE titleview
SET price = price * 1.10
WHERE pub_id = '0736'
GO

Answer / chamin

You can't do it in data bound mode for SQL Server 2000.It
gives an error called
"Insufficient key column information for updating or refreshing"

what is definer rights invoke rights?

1 Answers  

What are the features of pl sql?

1 Answers  

Is sql a backend language?

1 Answers  

Is not equal in sql?

1 Answers  

What is the need of a partition key?

1 Answers  

Why stored procedures are faster than query?

1 Answers  

Is null operator in sql?

1 Answers  

What is mutating table?

11 Answers   Saama Tech,

difference between SQL and C

1 Answers   Indus Software Technologies,

what is union, minus and interact commands? : Sql dba

1 Answers  

How to fix oracle error ora-00942: table or view does not exist

1 Answers  

How would you pass hints to the sql processor?

1 Answers