- **SELECT @@autocommit**: Retrieves the current autocommit setting for the session. Autocommit controls whether each SQL statement is automatically committed after execution or if manual transaction ...

This statement will start a new transaction and allow you to execute multiple SQL statements as a single unit of work. When you are ready to commit the transaction, you can use the COMMIT statement.