Transaction Keywords¶
This page lists SQL keywords and clauses related to transactions, including how to begin, commit, and roll back transactions, as well as advanced features such as savepoints and isolation levels. It also describes the corresponding methods available in ts-sql-query to manage transactional behavior in a type-safe way.
| SQL Keyword | ts-sql-query Equivalent | Notes | Link |
|---|---|---|---|
| BEGIN | connection .beginTransaction(), connection .transaction(...) |
Begins a new transaction. | Transaction, Connection API |
| BEGIN TRANSACTION | connection .beginTransaction(), connection .transaction(...) |
Begins a new transaction. | Transaction, Connection API |
| START | connection .beginTransaction(), connection .transaction(...) |
Begins a new transaction. | Transaction, Connection API |
| START TRANSACTION | connection .beginTransaction(), connection .transaction(...) |
Begins a new transaction. | Transaction, Connection API |
| COMMIT | connection .commit() |
Commits the current transaction. | Transaction, Connection API |
| COMMIT TRANSACTION | connection .commit() |
Commits the current transaction. | Transaction, Connection API |
| ROLLBACK | connection .rollback() |
Rolls back the current transaction. | Transaction, Connection API |
| ROLLBACK TRANSACTION | connection .rollback() |
Rolls back the current transaction. | Transaction, Connection API |
| SAVEPOINT name | Planned for future versions of ts-sql-query. |
Creates a named savepoint in the current transaction. | Transaction, Connection API |
| ROLLBACK TO name | Planned for future versions of ts-sql-query. |
Rolls back to the specified savepoint. | Transaction, Connection API |
| ROLLBACK TO SAVEPOINT name | Planned for future versions of ts-sql-query. |
Rolls back to the specified savepoint. | Transaction, Connection API |
| ROLLBACK TRANSACTION TO name | Planned for future versions of ts-sql-query. |
Rolls back to the specified savepoint. | Transaction, Connection API |
| ROLLBACK TRANSACTION TO SAVEPOINT name | Planned for future versions of ts-sql-query. |
Rolls back to the specified savepoint. | Transaction, Connection API |
| RELEASE name | Planned for future versions of ts-sql-query. |
Deletes a savepoint, making it unavailable for future rollbacks. | Transaction, Connection API |
| RELEASE SAVEPOINT name | Planned for future versions of ts-sql-query. |
Deletes a savepoint, making it unavailable for future rollbacks. | Transaction, Connection API |
| ISOLATION LEVEL READ UNCOMMITTED | connection .beginTransaction( connection .isolationLevel('read uncommitted')) |
Transaction isolation level. Used when beginning a transaction. | Transaction, Connection API |
| ISOLATION LEVEL READ COMMITTED | connection .beginTransaction( connection .isolationLevel('read committed')) |
Transaction isolation level. Used when beginning a transaction. | Transaction, Connection API |
| ISOLATION LEVEL REPEATABLE READ | connection .beginTransaction( connection .isolationLevel(('repeatable read')) |
Transaction isolation level. Used when beginning a transaction. | Transaction, Connection API |
| ISOLATION LEVEL SNAPSHOT | connection .beginTransaction( connection .isolationLevel('snapshot')) |
Transaction isolation level. Used when beginning a transaction. | Transaction, Connection API |
| ISOLATION LEVEL SERIALIZABLE | connection .beginTransaction( connection .isolationLevel('serializable')) |
Transaction isolation level. Used when beginning a transaction. | Transaction, Connection API |
| READ ONLY | connection .beginTransaction( connection .isolationLevel('read only')) |
Transaction read mode. Used when beginning a transaction. | Transaction, Connection API |
| READ WRITE | connection .beginTransaction( connection .isolationLevel('read write')) |
Transaction read mode. Used when beginning a transaction. | Transaction, Connection API |