Application lockApplication locks open up the whole world of SQL Server locks for custom uses within applications. Instead of using data as a locked...
Locking behaviorThere are various resources for learning SQL Lock behavior, including https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2...
About XACT_ABORT()What makes this difficult is that most errors do not stop processing , so when you have a group of modification statements running in a...