Discussion on question by Triynko: In the following inventory system, is it possible to force row locks to avoid deadlock and ensure it works as intended?

Discussion on question by Triynko: In the following inventory system, is it possible to force row locks to avoid deadlock and ensure it works as intended?

Database Administrators

Imported from a comment discussion on https://dba.stackexchange.com/questions/246888/in-the-following-inventory-system-is-it-possible-to-force-row-locks-to-avoid-de

concurrency deadlock locking sql-server-2019 t-sql
first message2019-09-04
last message1757 days ago
join this room
view transcript
36
3

Owners of this room

Paul White

Paul White ♦

87.9k 30 425 678
Moderator on Database Administrators