Implict transaction in query1 is making sql server to commit for every insert statement. Explicit transaction in query2 performs commit only once after the loop ends.
@GB-bv4sm11 ай бұрын
it is the result of poor or improper handling of Transactions in a SQL batch.