Explanation:transaction_name specifies a transaction name assigned by a previous BEGIN TRANSACTION. transaction_name must conform to the rules for identifiers 2. Point out the correct statement :
A. ROLLBACK TRANSACTION with a savepoint_name or transaction_name rolls back to the beginning of the transaction.
B. A ROLLBACK TRANSACTION statement does produce any messages to the user
C. Issuing a COMMIT TRANSACTION when @@TRANCOUNT is 0 results in an error
D. All of the mentioned
Answer:A
Explanation:transaction_name specifies a transaction name assigned by a previous BEGIN TRANSACTION. transaction_name must conform to the rules for identifiers 2. Point out the correct statement :
A. ROLLBACK TRANSACTION with a savepoint_name or transaction_name rolls back to the beginning of the transaction. B. A ROLLBACK TRANSACTION statement does produce any messages to the user C. Issuing a COMMIT TRANSACTION when @@TRANCOUNT is 0 results in an error D. All of the mentioned
Explanation: Error condition implies that there is no corresponding BEGIN TRANSACTION. 3. ____________ is the preferred statement for indicating errors in the transaction.