Hey folks: I want to clarify a few things about locks on updates:
1- can two processes update the same table if they are updating different rows?
2- in the event of two processes trying to update the same row, does this always result in a deadlock?
3- is there a way to create a system whereby potentially concurrent processes can update the same row in a given table, can the server be made to queue those updates, etc?
Is it just a no-go to try and have a situation where concurrent processes are trying to update the same record?