I'm seeking opinions regarding a stored procedure coding practice that I
keep running into.
At a high level, here's what I'm dealing with:
One stored procedure that contains a loop with calls to several other stored
create procedure A
while (some condition)
exec B (with some parameters)
exec C (with some parameters)
exec D (with some parameters)
exec E (with some parameters)
Stored procedures B,C,D and E do not contain explicit transactions.
Procedures B,C,D and E also are not called separately by any other part of
the system. I ...