I WANT TO KNOW IF , THE CONCURRENCY IN SQL IS REAL O LIKE REAL . I UPDATE ANY TABLES ON DIFERENTS REGISTER , BUT , ANY TIMES , ANY TRANSACTIONTS IS WRONG. MSG= DEAD LOCK OR THE TRANSACTIONS IS STOPED.
You can alter the concurrency with a set statement, if you want/need to. Deadlocks are usually due to a bad access path/bad index plan. You can add trace flags to capture info on the deadlock source/victim, then work on resolving it.