You need to identify how many rows will be in dbo.Table1 after you execute the code. How many rows should you identify?
A. 0
B. 1
C. 2
D. 3
One Comment on “How many rows should you identify?”
malakosasays:
A is correcr
Explanation:
A transaction cannot be rolled back after a COMMIT TRANSACTION statement is executed, except when the COMMIT TRANSACTION is associated with a nested transaction that is contained within the transaction being rolled back. In this instance, the nested transaction will also be rolled back, even if you have issued a COMMIT TRANSACTION for it.
A is correcr
Explanation:
A transaction cannot be rolled back after a COMMIT TRANSACTION statement is executed, except when the COMMIT TRANSACTION is associated with a nested transaction that is contained within the transaction being rolled back. In this instance, the nested transaction will also be rolled back, even if you have issued a COMMIT TRANSACTION for it.
1
0