摘要:
利用Sql server 悲观锁定原理,加事务TRAN和锁定with (UPDLOCK)BEGIN TRANDECLARE @max_bom_id BIGINTSELECT @max_bom_id=ISNULL(CONVERT(BIGINT,param_value),201000000000)+1 FROM pln_klsz_calculate_param_def with (UPDLOCK) WHERE param_type=10 AND param_id=10101015 -- 延迟秒,模拟并发访问. wai... 阅读全文