A successful implicit or explicit transaction comes to a close with this. COMMIT TRANSACTION releases the transaction’s resources, decreases @@TRANCOUNT to 0, and, if @@TRANCOUNT is 1, makes all data alterations made since the transaction began a permanent part of the database.

You can simply fire commit command , if you are using transactions in SQL. You can also use Autocommit to automatically commit the transaction when it is finished. This will not let you to fire commit command. You can find all the uncommited transactions through DBCC opentran; command.

Marks the end of a successful implicit or explicit transaction. If @@TRANCOUNT is 1, COMMIT TRANSACTION makes all data modifications since the start of the transaction a permanent part of the database, frees the transaction’s resources, and decrements @@TRANCOUNT to 0.

The completion of a successful implicit or explicit transaction. If @@TRANCOUNT equals 1, COMMIT TRANSACTION makes any data alterations since the start of the transaction a permanent part of the database, frees the transaction’s resources, and decrements @@TRANCOUNT to 0.