Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pavan_1981
A mutating table is a table that is currently being
modified by an update, delete, or insert statement. For
example, if your trigger contains a select statement or an
update statement referencing the table it is triggering off
of you will receive the error.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the table the trigger is triggering off of.
| Is This Answer Correct ? | 124 Yes | 5 No |
Post New Answer View All Answers
What does t sql mean?
what is sp_pkeys? : Transact sql
What is a column in a table?
What are the different types of joins in sql?
How many types of indexes are there in sql?
What are the benefits of pl sql?
what are the performance and scalability characteristics of mysql? : Sql dba
Does a primary key have to be a number?
What is the need of a partition key?
Do we need commit after truncate?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Explain architecture of sql server notification services?
what is the difference between cluster and non cluster index? : Sql dba
What is sql not null constraint?
What is difference between sql and oracle?
