3 ms·
> Multiple SQL statements executed inside stored procedures are not run any more atomically than multiple SQL statements executed from application layer. Yes,
by jimktrains2 7y ago
> Multiple SQL statements executed inside stored procedures are not run any more atomically than multiple SQL statements executed from application layer.
Yes, but not wrapping those multiple application-generated queries in a transaction is a common bug I've encountered at many of the places I've worked. It also requires a lot more round-trips to the database.