2 improved formatting
source | link

Use "Go" to separate the transactions. That will solve the issue. ( Its easy than run one by one.) Also can change the Isolation level ( Not tested )

SET TRANSACTION ISOLATION LEVEL SERIALISABLE

Begin tran

---Statements goes here

commit tran

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SET TRANSACTION ISOLATION LEVEL SERIALISABLE

Begin tran

---Statements goes here

commit tran

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Use "Go" to separate the transactions. That will solve the issue. ( Its easy than run one by one.) Also can change the Isolation level ( Not tested )

SET TRANSACTION ISOLATION LEVEL SERIALISABLE

Begin tran

---Statements goes here

commit tran

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Use "Go" to separate the transactions. That will solve the issue. ( Its easy than run one by one.) Also can change the Isolation level ( Not tested )

SET TRANSACTION ISOLATION LEVEL SERIALISABLE

Begin tran

---Statements goes here

commit tran

SET TRANSACTION ISOLATION LEVEL READ COMMITTED
1
source | link

Use "Go" to separate the transactions. That will solve the issue. ( Its easy than run one by one.) Also can change the Isolation level ( Not tested )

SET TRANSACTION ISOLATION LEVEL SERIALISABLE

Begin tran

---Statements goes here

commit tran

SET TRANSACTION ISOLATION LEVEL READ COMMITTED