How to use [mssql.transaction.commit]
The reference page of mssql.transaction.commit has its arguments, constraints and declaration.
This slot commits the open transaction. It works like [data.transaction.commit]. Without it a transaction is rolled back when it leaves scope. Below is an example.
mssql.connect:sakila
mssql.transaction.create
mssql.execute:update actor set last_name = 'Smith' where actor_id = 1
mssql.transaction.commit