What happens if you don’t commit a transaction to a database (say, SQL Server)?

As long as you don’t COMMIT or ROLLBACK a transaction, it’s still “running” and potentially holding locks.

If your client (application or user) closes the connection to the database before committing, any still running transactions will be rolled back and terminated.