Subject Procedures and transactions
Author Gerhardus Geldenhuis
My scenario will explain the best.

procedure dosomething
for select * from TableA do
//externally somebody adds/remove/change something to tableA.
//I do the the same selection again.
for select * from TableA do

will the second for loops be the same as the first one.
How does transactions works in the context of stored procedures?