Microsoft SQL Server Knowledge Bank: COMMIT and ROLLBACK TRANSACTION in Triggers

Where I am using a ROLLBACK TRAN in a trigger (INSTEAD OF DELETE trigger), he had a question on mid that without using the BEGIN TRANSACTION on the Trigger, can we us the ROLLBACK TRANSACTION. It is better, if you read my previous article to ...

sqlknowledgebank.blogspot.com