Error ' 80004005 ' deadlock on lock resource reason

The Microsoft OLE DB Provider for SQL Server error ' 80004005 ' transaction (process ID) and another process have been deadlocked on the lock resource and the transaction has been selected as a deadlock victim. Please run the transaction again.

The reason is that your database in the concurrent INSERT, delete, update the same record, to lock, and concurrent, so lock the

The result of this method is to solve the problem of concurrent query from the program design

For example, the operation of the same record is temporary, cached, followed by automatic execution of the queue