Monday, February 20, 2012

Is commit needed in stored procedure?

If I have a stored pocedure that just does one simple update command, do I need a commit after the update even if it is not part of a transaction. Or does it commit automatically? Thanks!

You only need COMMIT if you are using transactions.

-Damien

|||

If it's not part of a transaction, you won't need to commit it as it will be done automatically.

No comments:

Post a Comment