Difference between revisions of "SQL END TRANSACTION"
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Commit changes made during a transaction and close the transaction | Commit changes made during a transaction and close the transaction | ||
| − | |||
==Syntax== | ==Syntax== | ||
| Line 9: | Line 8: | ||
END TRANSACTION [<transaction>] | END TRANSACTION [<transaction>] | ||
| − | |||
==See Also== | ==See Also== | ||
[[SQL BEGIN TRANSACTION| BEGIN TRANSACTION]], [[COMMIT]], [[SQL ROLLBACK|ROLLBACK]], [[SAVE TRANSACTION]], [[SAVEPOINT]], [[SET TRANSACTION]], [[TXNISOLATION()]], [[TXNLEVEL()]] | [[SQL BEGIN TRANSACTION| BEGIN TRANSACTION]], [[COMMIT]], [[SQL ROLLBACK|ROLLBACK]], [[SAVE TRANSACTION]], [[SAVEPOINT]], [[SET TRANSACTION]], [[TXNISOLATION()]], [[TXNLEVEL()]] | ||
| − | |||
==Description== | ==Description== | ||
| Line 23: | Line 20: | ||
The optional <transaction> is a name for the transaction. This name can be used by the COMMIT and ROLLBACK statements. | The optional <transaction> is a name for the transaction. This name can be used by the COMMIT and ROLLBACK statements. | ||
| − | |||
==Example== | ==Example== | ||
| Line 41: | Line 37: | ||
END TRANSACTION | END TRANSACTION | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
| − | + | Lianja Server, Lianja | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL|END TRANSACTION]] | [[Category:SQL|END TRANSACTION]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Latest revision as of 10:10, 11 December 2012
Purpose
Commit changes made during a transaction and close the transaction
Syntax
BEGIN TRANSACTION [<transaction>]
<statements>
END TRANSACTION [<transaction>]
See Also
BEGIN TRANSACTION, COMMIT, ROLLBACK, SAVE TRANSACTION, SAVEPOINT, SET TRANSACTION, TXNISOLATION(), TXNLEVEL()
Description
The BEGIN TRANSACTION statement is used to flag the beginning of a transaction. The END TRANSACTION statement is used to commit changes made during the transaction and close the transaction. The COMMIT statement and the ROLLBACK statement can also be used to close a transaction. The COMMIT statement will save the changes made and the ROLLBACK statement will discard the changes made.
Transactions can be nested by issuing a second or subsequent BEGIN TRANSACTION before an existing transaction has been closed. The TXNLEVEL() function returns the current transaction nesting level. When a transaction is closed, transactions nested within it are also closed.
Savepoints can be set during a transaction. These identify stages within the transaction which can subsequently be used as ROLLBACK points.
The optional <transaction> is a name for the transaction. This name can be used by the COMMIT and ROLLBACK statements.
Example
BEGIN TRANSACTION trans1 INSERT INTO customer; (TITLE, LAST_NAME, FIRST_NAME, INITIAL, STREET,; CITY, STATE, ZIP,LIMIT, START_DATE); VALUES; ('Ms', 'Jones', 'Susan', 'B', '177 High Street','Beverly', 'MA', '01915', 2000, date()) INSERT INTO accounts (ORD_VALUE) VALUES (30) BEGIN TRANSACTION trans2 INSERT INTO accounts (ORD_VALUE) VALUES (60) // Rollback the trans1 transaction and any transactions // nested in trans1 ROLLBACK TRANSACTION trans1 END TRANSACTION
Products
Lianja Server, Lianja
