Manually submit changes in SQL Server Management Studio

Previously, PL/SQL was used as a database management tool. All executed changes must be committed to the database by pressing the submit button. Later, SQL Server Management studio was used, it is a method of automatic submission, especially in the production environment. It is always like a thin ice, worrying about anything.

 

 

The settings for disabling automatic submission in SQL Server Management studio are as follows:

In option-query execution-SQL Server-ANSI, check "set_implicit_transactions"

 

There are two submission methods. One is to explicitly execute "commit;", and the other is to display the following window when the query window is closed. You can select submit or rollback here.

 

Unfortunately, there is still no way to manually submit the changes in the data editor.