TechQA.

Question

How to continue a transaction when OPENJSON throws an error?

score 77 · Answer 1 · 2023-11-18T07:22:02.267000

0

Answer

77

Views

How to continue a transaction when OPENJSON throws an error?

77 views Asked by user1828271 At 18 November 2023 at 07:22

score 4232 · Answer 2 · 2021-11-05T07:15:51.080000

How to use SET XACT_ABORT ON the right way

4.2k views Asked by Francesco Mantovani At 05 November 2021 at 07:15

score 463 · Answer 3 · 2021-04-06T12:08:06.500000

SQL Server - Try-Catch / xact_abort off and xact_state

463 views Asked by Adrian Parker At 06 April 2021 at 12:08

score 870 · Answer 4 · 2020-05-29T06:58:51.793000

EF Core set XACT_ABORT for all database connections

870 views Asked by l3utterfly At 29 May 2020 at 06:58

score 411 · Answer 5 · 2018-07-28T13:31:35.440000

Why SQL Server stored procedure selecting encrypted data into variable fails

411 views Asked by Maxim At 28 July 2018 at 13:31

score 240 · Answer 6 · 2018-03-08T10:26:01.837000

Transactions Rolling Back by default when XACT_ABORT is off

240 views Asked by SE1986 At 08 March 2018 at 10:26

score 9502 · Answer 7 · 2017-04-03T18:59:14.823000

Why does SQL Server default XACT_ABORT to OFF? Can it be set to ON globally?

9.5k views Asked by HappyTown At 03 April 2017 at 18:59

score 6376 · Answer 8 · 2016-07-19T14:21:37.490000

Transactions breaking when using SP_ExecuteSQL

6.3k views Asked by Ivan Pintar At 19 July 2016 at 14:21

score 1056 · Answer 9 · 2016-06-27T19:24:03.103000

SQL Server XACT_ABORT with exclusion

1k views Asked by Eli At 27 June 2016 at 19:24

score 998 · Answer 10 · 2015-01-23T15:07:41.710000

SQL Server 2005: Confusion using XACT_ABORT=ON with TRY...CATCH

998 views Asked by RobW At 23 January 2015 at 15:07

score 636 · Answer 11 · 2014-05-01T17:40:47.227000

SET XACT_ABORT ON Being ignored, transaction continues (SQL Server 2008 R2)

636 views Asked by test-in-prod At 01 May 2014 at 17:40

score 741 · Answer 12 · 2014-01-09T20:07:53.340000

Are these code snippets equivalent ('set xact_abort on' vs 'try catch rollback')?

741 views Asked by Anatoly U At 09 January 2014 at 20:07

score 2454 · Answer 13 · 2013-09-04T15:59:06.200000

What is the scope of XACT_ABORT

2.4k views Asked by Guillermo Gutiérrez At 04 September 2013 at 15:59

score 240 · Answer 14 · 2013-08-28T00:32:41.013000

SET_XACT_ABORT ON in a transaction with rollback present in catch block

240 views Asked by TheWommies At 28 August 2013 at 00:32

score 5135 · Answer 15 · 2013-04-23T15:37:35.660000

Transaction handling in Trigger (TRY/CATCH....XACT_ABORT ON)

5.1k views Asked by Ramon Gonzalez At 23 April 2013 at 15:37

score 16092 · Answer 16 · 2013-04-05T16:59:09.530000

set xact_abort on and try catch together

16k views Asked by satuday At 05 April 2013 at 16:59

score 952 · Answer 17 · 2013-03-16T20:40:13.343000

Trigger exits on first failed insert and cant set xact_abort OFF in SQL Server 2000

952 views Asked by LDM At 16 March 2013 at 20:40

score 2121 · Answer 18 · 2012-12-10T14:30:28.727000

How to retrieve error code and message when distributed tx fails? (MS DTC)

2.1k views Asked by spse At 10 December 2012 at 14:30

score 2581 · Answer 19 · 2012-11-08T14:31:28.170000

What is the effect of having XACT_ABORT on/off in parent/child stored procedures respectively?

2.5k views Asked by Will Weld At 08 November 2012 at 14:31

score 7275 · Answer 20 · 2012-07-23T19:36:54.013000

How to make SET XACT_ABORT ON rollback the transaction?

7.2k views Asked by Ian Boyd At 23 July 2012 at 19:36

TechQA.

List Question

How to continue a transaction when OPENJSON throws an error?

How to use SET XACT_ABORT ON the right way

SQL Server - Try-Catch / xact_abort off and xact_state

EF Core set XACT_ABORT for all database connections

Why SQL Server stored procedure selecting encrypted data into variable fails

Transactions Rolling Back by default when XACT_ABORT is off

Why does SQL Server default XACT_ABORT to OFF? Can it be set to ON globally?

Transactions breaking when using SP_ExecuteSQL

SQL Server XACT_ABORT with exclusion

SQL Server 2005: Confusion using XACT_ABORT=ON with TRY...CATCH

SET XACT_ABORT ON Being ignored, transaction continues (SQL Server 2008 R2)

Are these code snippets equivalent ('set xact_abort on' vs 'try catch rollback')?

What is the scope of XACT_ABORT

SET_XACT_ABORT ON in a transaction with rollback present in catch block

Transaction handling in Trigger (TRY/CATCH....XACT_ABORT ON)

set xact_abort on and try catch together

Trigger exits on first failed insert and cant set xact_abort OFF in SQL Server 2000

How to retrieve error code and message when distributed tx fails? (MS DTC)

What is the effect of having XACT_ABORT on/off in parent/child stored procedures respectively?

How to make SET XACT_ABORT ON rollback the transaction?

Popular Questions

Trending Questions