摘要:
SET LOCK_TIMEOUT 1800 SET TRANSACTION ISOLATION LEVEL READ COMMITTED BEGIN TRANSACTION DECLARE @PRD_NO VARCHAR(30)DECLARE @CUS_NO VARCHAR(20)DECLARE @STD_LEVEL VARCHAR(10)DECLARE @USR VARCHAR(12) DECLARE MY_CURSOR CURSOR FORSELECT DISTINCT PRD_NO,CUS_NO,STD_LEVEL,USR FROM CUS_ML_GGEC HOLDLOCK WHERE. 阅读全文
摘要:
1 如何锁一个表的某一行A 连接中执行SET TRANSACTION ISOLATION LEVEL REPEATABLE READbegin transelect * from tablename with (rowlock) where id=3waitfor delay '00:00:05'commit tranB连接中如果执行update tablename set colname='1... 阅读全文