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

Why use stored procedures?

1063

Which is faster truncate or drop?

1030

What are the two types of periodical indexes?

925

Which certification is best for sql?

974

What are types of joins?

949

What is the difference between pl and sql?

1077

What are the various restrictions imposed on view in terms of dml?

957

What is cursor and its types?

1048

how to get @@error and @@rowcount at the same time? : Sql dba

1010

What are the different schemas objects that can be created using pl/sql?

1005

How do I remove duplicates in two columns?

1033

What is mutating error in pl sql?

1003

Is primary key clustered or nonclustered?

992

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2462

What does rownum mean in sql?

1011