COMMIT TRANSACTION ?
COMMIT TRANSACTION ?
When Why and How would i use COMMIT TRANSACTION, anyone care to present a scenario ?
Re: COMMIT TRANSACTION ?
I use it often.
1st, I often call a stored procedure at the end of an aware process. I have to commit so that the SP can read / update the correct data. (I use many SPs in my apps.)
2nd, I sometimes update something in SystemSettings in the middle of a long process. (One that prompts user for info ) and want to make sure when other users read SystemSettings they get the current version.
Bruce
1st, I often call a stored procedure at the end of an aware process. I have to commit so that the SP can read / update the correct data. (I use many SPs in my apps.)
2nd, I sometimes update something in SystemSettings in the middle of a long process. (One that prompts user for info ) and want to make sure when other users read SystemSettings they get the current version.
Bruce
Re: COMMIT TRANSACTION ?
Thanks , that makes sense, I can see in some of my processes it could be used rather than dropping down (referring to) another process in the sequence