There is a legacy system which has a stored procedure with Begin Transaction and Commit but there is no rollback transaction. It has a simple if record exists condition then inserts or updates the record accordingly.
What would happen if there is a problem during the table update ? What would happen for the opened transaction?
Please advise.