can we update a view which is created from two tables

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database white box testing and black box testing?

626


What is dynamic sql in pl sql?

481


Why function is used in sql?

510


what does the t-sql command ident_incr does? : Transact sql

591


How do sql databases work?

523






what is datawarehouse? : Sql dba

559


Define union, minus, union all, intersect ?

545


What is mutating table error?

650


How to use distinct and count in sql query? Explain

601


Where not exists in sql?

497


What is pivot in sql?

504


What is trigger explain with example?

540


Are subqueries faster than joins?

562


How do I count rows in sql query?

482


Are pl sql variables case sensitive?

587