Interested to Buy Any Domain ? << Click Here >> for more details...
Which one of the following is a reason that an INSERT
statement might cause an error instead of executing
correctly?
1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.
2. The INSERT statement was attempting to insert a record
using a combination of constants and values from an
existing table.
3. The INSERT statement was attempting to insert a record
with a non-NULL value into a table that has that column
defined as NULL.
4. The INSERT statement was attempting to insert a record
into a table by selecting a record from that same table.
5. The INSERT statement was attempting to insert a record
into a view rather than a table.
- 1 Answers
- 6602 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / tulsi
1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.
we cannot modify more than one base table through a join
view.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is mutating error?
is mysql query is case sensitive? : Sql dba
What is sqlerrd?
How to know the last executed procedure?
What is prepared statement in sql?
How to run sql statements with oracle sql developer?
How do I run a sql query?
Which normal form is best?
how many tables will create when we create table, what are they? : Sql dba
What is the difference between a procedure and a function?
What is sqlcommand?
What is normalization in a database?
Why trigger is used in sql?
What is clustered index in sql?
Which table is left in join?
