Transaction Mode Support

Microsoft SQL Server used auto-commit and auto-rollback transaction. If we haven't specified 'begin transaction' command or 'begin distributed transaction' command before we execute a sql command, the DBMS will use auto-commit and auto-rollback transaction.

But we need often manual transaction by reason of many operations. SQLFactory will simulate the realization to help user reduce code.

Click 'Begin Transaction' command to enter the transaction mode in the toolbar or the query menu.

Click 'Commit Transaction' command to commit and terminate the transaction mode in the toolbar or the query menu.

Click 'Rollback Transaction'command to rollback and terminate the transaction mode in the toolbar or the query menu.