transactions (SQL Server)First, the concept of businessA transaction is a mechanism, a sequence of operations, that contains a set of database operations commands that either execute all or do not. Therefore, a transaction is an inseparable unit of
Sqlserver2000 transaction processing in server|sqlserver| transaction processing I. Definition and its nature: transaction: A series of actions performed as a single logical unit of work. Attribute: A logical unit of work must have four
1. What is a transaction:A transaction is a rigorous set of operations in a program, and all operations must be completed successfully, or changes made in each operation will be undone, which is the atomicity of the transaction (either success or
1. What is a transaction:A transaction is a rigorous set of operations in a program, and all operations must be completed successfully, or changes made in each operation will be undone, which is the atomicity of the transaction (either success or
1. What is a transaction:A transaction is a rigorous set of operations in a program, and all operations must be completed successfully, or changes made in each operation will be undone, which is the atomicity of the transaction (either success or
1. What is a transaction:A transaction is a rigorous set of operations in a program, and all operations must be completed successfully, or changes made in each operation will be undone, which is the atomicity of the transaction (either success or
1. What is a transaction:A transaction is a rigorous set of operations in a program, and all operations must be completed successfully, or changes made in each operation will be undone, which is the atomicity of the transaction (either success or
Introduction to XA transactionsThe basis of an XA transaction is a two-phase commit protocol. There is a need for a coordinator of the transaction to ensure that all the transaction participants have completed the preparatory work (phase I). If the
perform a two-step commit OverviewThis section provides a multi-record update or multi-record transaction, using a two-step commit to complete a multi-record write template. In addition, this method can be extended to provide rollback-like
Basic concept Local Coordinator: In a distributed transaction, you must refer to the data on other nodes to complete the site of this part of your operation. Global Coordinator: The initiator of the distributed transaction, responsible for
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.