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.
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 sp_helptext?
What is the difference between cross join and natural join?
what is auto increment? : Sql dba
how to run 'mysql' commands from a batch file? : Sql dba
How do I add a primary key to a table?
What is #table in sql?
Define the select into statement.
Can we alter stored procedure?
What is the difference between sql and mysql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What are the types of index in sql?
Is microsoft sql free?
Does truncate require commit?
What is case function?
How do I count rows in sql query?