994076 wrote:I didn't ask you to repeat yourself, I asked WHY you think that should happen.
I expect the second transaction will return an error message saying that the table has been lock?
The problem is i use some SOP and i manage to capture the 1st transaction is in the process and the 2nd transaction is completed.Nope. Perform more research. Might be that your particular DBMS simply doesn't properly support this type of locking, or it will lock on the row and not the table.