Database consultancy & Services

NTransactions Using SQL

The SQL language is fundamentally transactional in nature. There are a number of database implementations of the SQL standard in use today which extend the language and implement an explicit “START TRANSACTION” statement; however, this action simply deactivates the auotcommit statement. After this point, no operations on the database become visible to other uses of the data store until a COMMIT statement is process by the system. A SQL ROLLBACK statement can also be executed which will undo any work conducted on the system since the last successful transaction. The ROLLBACK and COMMIT statements will conclude a transaction and start the next. If the DBMS disabled the autocommit feature using a START TRANSACTION statement, it will be re-enabled. Alternative implementations of SQL also use the following statements: BEGIN, BEGIN WORK, and BEGIN TRANSACTION.