If I insert and Update on the same table at the same time, will it create a deadlock?
Thanks in Advance
Printable View
If I insert and Update on the same table at the same time, will it create a deadlock?
Thanks in Advance
Sorry, I don't have access to metalink. Any suggestion
If the Insert and update is within the same session then no, the premiss behind a deadlock is that sessionA requests an object which is locked by sessionB at the same time sessionB is attempting to use the object SessionA is locking.
Regards