I open a (repeatable read) transaction (
BEGIN TRAN) to do some work on certain records. First thing I do is checking if the data I need to change is in the database. In some cases there will be and then I proceed to my changes. But in some cases there will be nothing to do. In this case I either
COMMIT TRAN or
ROLLBACK TRAN and return from the stored procedure. At this time no changes were done to the data yet, so the effect of commit and rollback is the same.
Are there any consideration I should be aware about to chose between commit and rollback? Is there different performance cost? Other considerations?