Transaction Mode in SQL

77 Views Asked by At

I was reading through the BNF grammar for transaction statements and saw that transaction modes can be specified directly in the START TRANSACTION statement. Is there a difference in specifying transaction modes in START TRANSACTION vs SET TRANSACTION statements?

1

There are 1 best solutions below

4
On BEST ANSWER

No difference. The SET TRANSACTION setting only affects the single next transaction to be started.

Use SET SESSION to set the default for the session's transactions.