当前位置:网站首页>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