— The Forums are now read-only —
— All new activity now takes place here: —
Notifications
Clear all
Votes Received: 1
AugSQL
1
Posts
1
Users
1
Reactions
752
Views
May 9, 2023 3:47 pm
Not sure if this would be possible, but it would be nice to be able to use the BEGIN TRAN, ROLLBACK TRAN, and COMMIT TRAN SQL statements. They are useful when doing UPDATE and DELETE statements because you can do something like:
BEGIN TRAN UPDATE Table SET Column='New Value" WHERE...
then make sure that the number of rows updated is the number of rows that you expected to update.
This allows you to ROLLBACK TRAN or COMMIT TRAN accordingly.
July 9, 2023 4:52 pm
Currently this is what happens when you try to do BEGIN TRAN, then COMMIT TRAN:
By using this website, you agree to our Terms of Use (click here)
