此代碼用于解決存儲(chǔ)過(guò)程間嵌套調(diào)用時(shí)的全局原子性問(wèn)題:
DECLARE @TranStarted bit
SET @TranStarted = 0
IF( @@TRANCOUNT = 0 ) -- 用于嵌套
BEGIN
BEGIN TRANSACTION
SET @TranStarted = 1
END
ELSE
SET @TranStarted = 0
.....
IF( @TranStarted = 1 )
BEGIN
SET @TranStarted = 0
COMMIT TRANSACTION
END
新聞熱點(diǎn)
疑難解答
圖片精選