22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT @@TRANCOUNT AS A
SET XACT_ABORT ON ;
BEGIN TRY
BEGIN TRAN
SELECT @@TRANCOUNT AS A1
INSERT INTO A2A ( ID1 )
VALUES ( 'A' )
COMMIT TRAN;
END TRY
BEGIN CATCH
SELECT @@TRANCOUNT AS A2
ROLLBACK TRAN;
SELECT ERROR_MESSAGE() AS ErrorMessage ,
ERROR_SEVERITY() AS ErrorSeverity ,
ERROR_STATE() AS ErrorState
END CATCH
SELECT @@TRANCOUNT AS B
SET XACT_ABORT OFF
SELECT @@TRANCOUNT AS A
BEGIN TRY
BEGIN TRAN
SELECT @@TRANCOUNT AS A1
INSERT INTO A2A ( ID1 )
VALUES ( 'A' )
OPTION(RECOMPILE)
COMMIT TRAN;
END TRY
BEGIN CATCH
SELECT @@TRANCOUNT AS A2
ROLLBACK TRAN;
SELECT ERROR_MESSAGE() AS ErrorMessage ,
ERROR_SEVERITY() AS ErrorSeverity ,
ERROR_STATE() AS ErrorState
END CATCH
SELECT @@TRANCOUNT AS B
SELECT @@TRANCOUNT AS A
BEGIN TRY
BEGIN TRAN
SELECT @@TRANCOUNT AS A1
INSERT INTO A2A ( ID1 )
VALUES ( 'A' )
COMMIT TRAN;
END TRY
BEGIN CATCH
SELECT @@TRANCOUNT AS A2
ROLLBACK TRAN;
SELECT ERROR_MESSAGE() AS ErrorMessage ,
ERROR_SEVERITY() AS ErrorSeverity ,
ERROR_STATE() AS ErrorState
END CATCH
SELECT @@TRANCOUNT AS B