I need to add place some TSQL into a TRANSACTION. I understand the pricipal but am confused by the ROLLBACK command.
If it did
DELETE OrderItems WHERE order_num = 12345
DELETE Orders WHERE order_num = 12345
Is there any point in having adding a ROLLBACK statement to this code. What would I gain from using a ROLLBACK command?