当前位置：网站首页>Sqlserver transaction and lock problem

Sqlserver transaction and lock problem

2022-04-23 14:50:00 【CSDN Q & A】

Excuse me, , If two things change or read a row of data at the same time , What will the lock of the first transaction do to the second transaction ？ End or pause ？



Take the answer ：

1、 Data was being updated during a transaction , Other transactions cannot be modified , You can only modify after the last transaction is completed , But it does not affect the reading of data ;
2、 There must be a sequence of transactions , Even if you click two at the same time, execute them together ;

版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204162344042286.html

边栏推荐

猜你喜欢

随机推荐