Have two application operation the same table A, one is through the datawindow preservation, A process is SQL Server storage preservation,

SQL Server stored procedure execution, datawindow operation very card,

Do you have any good solution?

CodePudding user response:

Operating in the same table, maybe waiting for a lock

CodePudding user response:

refer to the original poster qiyj1983 response:

, there are two applications operate the same table A, one is through the datawindow preservation, A process is SQL Server storage preservation,

SQL Server stored procedure execution, datawindow operation very card,

Do you have any good solution?

Is not the problem of card, is the problem of concurrency, table is locked, need to pay attention to the data window or the background after the success of the stored procedure execution, must commit, or lock table, can only wait for others

CodePudding user response:

Top webmaster

Lock problem, the transaction must be submitted in time.