You can't do it in data bound mode for SQL Server 2000.It gives an er

can we update a view which is created from two tables

Question Posted / chamin

Answer Posted / 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"

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is set serveroutput on?

1086

What is data profiling in sql?

1014

Is oracle sql free?

926

How much does sqlite cost?

982

What type of database is cloud sql?

1040

Is json a nosql?

914

How do I run a script in sql developer?

894

What is faster join or subquery?

957

What is a ddl command?

1003

What is cross join example?

940

what is 'trigger' in sql? : Sql dba

1008

How to use distinct and count in sql query? Explain

956

How do you declare a constant?

909

Can I create table without primary key?

937

What is an escape character in sql?

978