The statement ROLLBACK is identical to ROLLBACK WORK, ROLLBACK TRAN, and ROLLBACK TRANSACTION.ĭetermines how transactions can start and end.Įach statement runs under its own transaction and no explicit COMMIT or ROLLBACK statement is necessary.
No changes for the transaction are committed to the database. Rolls back a transaction to the beginning of the transaction.
The statement COMMIT is identical to COMMIT WORK, COMMIT TRAN, and COMMIT TRANSACTION. This statement causes the changes in the transaction to be permanently committed to the database. Marks the end of an explicit or autocommit transaction. Marks the starting point of an explicit transaction. Transact-SQL Syntax Conventions (Transact-SQL) Syntax BEGIN TRANSACTION In Azure Synapse Analytics, autocommit transactions begin immediately after a COMMIT or ROLLBACK statement, or after a SET AUTOCOMMIT OFF statement. When the AUTOCOMMIT setting is OFF, a COMMIT or ROLLBACK statement is required to determine the outcome of the transaction. When the AUTOCOMMIT setting is ON, each statement runs in a transaction and no explicit COMMIT or ROLLBACK is necessary. Azure Synapse Analytics supports the following types of transactions:Įxplicit transactions start with the BEGIN TRANSACTION statement and end with the COMMIT or ROLLBACK statement.Īuto-commit transactions initiate automatically within a session and do not start with the BEGIN TRANSACTION statement. The beginning and end of transactions depends on the AUTOCOMMIT setting and the BEGIN TRANSACTION, COMMIT, and ROLLBACK statements. If the transaction fails, that is at least one of the statements in the group fails, then the entire group is rolled back. If the transaction succeeds, all statements within it are committed. Each transaction is atomic, consistent, isolated, and durable (ACID). Applies to: Azure Synapse Analytics Analytics Platform System (PDW)Ī transaction is a group of one or more database statements that are either wholly committed or wholly rolled back.
0 kommentar(er)
