Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

END TRANSACTION Command

Visual Studio .NET 2003

Ends the current transaction and saves any changes made to tables, table memo files, or index files included in a transaction.

END TRANSACTION

Remarks

Any updates to the database that were made between the previous BEGIN TRANSACTION and the END TRANSACTION are committed. If the transaction is the first or only transaction (that is, the transaction isn't nested), the changes are written to disk.

If a transaction is nested, END TRANSACTION causes all cached updates to be folded into the next higher transaction level. Nesting transactions has the potential to overwrite changes made to data at a higher transaction level.

If END TRANSACTION generates an error (for example, there is insufficient disk space to write changes to disk), changes made during the transaction are cancelled and the transaction ends.

See Also

BEGIN TRANSACTION | ROLLBACK | TXNLEVEL( )

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.